Parsing data on a form from a single table file

[woodje]

Hello,

I have a table x with field17 and in this location I have a group of text of "CFACCESM04/18/05". I need to split this data from the table to 3 text boxes labeled txt1, txt2, and txt3. The first box (txt1 = the first 5 characters). The sencond box (txt2 = the next 3 characters). And the last box (txt3 = the last 8 characters).Can you please assist me with the coding to parse this data to these boxes correctly.

 

[PHV]

Take a look at the Left, Mid and Right functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244