Hi..

I have a text box called Reference. I have data to enter which all start with the letter "M". E.G. M2049, M2050 etc

How can I pre-define this text box that the letter "M" always appears.

Thank you in advance

Ruby

if Left(me.mytextbox, 1) = "M" then ....

Liv manto....


could you please tell me more...where shall i put that code and its unfinished, wat am i suppose to put in it...

thank you in advance for your help

ruby

Use an input mask.

Kevin...

how do I use the input mask...

thanks

ruby

In table design view, enter the following in the Input Mask properties...

"M"99999;0

You may need to update the field on your forms too.

HTH