Text values

[k209310]

Hello

I have written a function that allows a "/" to be entered automatically in to a text box at the required point. The format of teh text box is set to "Short Date"

If I type the date in by hand eg "12/12/2003" then i get no problems however if i set the function so that thee "/" is entered automatically an error message occurs telling me that the value i have entered is not valid for the field.

If i set the format to nothing then i get no problems however i need the format to be set to a date for other reasons.

Has anybody got any ideas about this

Cheers

Chris

 

[dcx693]

Did you try using an input mask to have Access enter the "/" characters for you?

 

[k209310]

dcx693

That would obviously be much easier.

Thanks