Replies

Hi there

the text file definitely has client numbers with leading zeros here is a snippet

NCH003|CL-Non ChargeableFiles|
NCH004|PC Unit Non Chargeable Files|
00002B|Bank of India|
00002C|Sheraton Caltrust |

if I put a client number which does not start with a zero it accepts it but with a zero it tells me it is invalid (I have programmed a message box in so if the person filling it in enters the wrong number in the field they cant get past unless they correct it). This is the point I find it is incorrect and it was one of the guys in the department who does SQL programming that suggested the dropping of the leading zeros was most likely the problem.

in answer to it being commented out first – I had just forgot to remove them before pasting it in – they are not present in the live form code. Both clrec and clnum are declared as strings but when the client number starts with a zero it knocks it off. This causes a problem because it then doesn’t appear to be 6 digits – for example one of our client numbers is 00002T. I need to get the code not to knock of any numbers. I dont feel I am explaining this very well but hopefully it now makes a little more sense

Thanks – it worked beautifully.

Hi there

thanks for the help, it worked a treat. Now I have the template attaching nicely but it is not appearing as an option to save any autotext entries into. Do you have any idea as to how I can get it to come up as an option

Thanks