Value in Text Box/field

[rupes_mahal]

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

 

[Liv Manto]

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

 

[rupes_mahal]

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

 

[KevinM]

Use an input mask.

 

[rupes_mahal]

Kevin...

how do I use the input mask...

thanks

ruby

 

[KevinM]

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