Input Mask

[Secret Squirrel]

I have a text box on my form that I have set up with an input mask of 0.0.
Is there a way to have it automatically enter the .0 if a user was to just
enter 1 instead of 1.0? Right now if you just enter a 1 you get an error
message that says you need to enter a value based on the input mask. I'd also
like to eliminate that default message and create my own message.

 

[Tom van Stiphout]

On Fri, 26 Sep 2008 18:06:01 -0700, Secret Squirrel

You want to have your cookie and eat it too. If you specify a mask of
0.0 then you specify that the user MUST enter that format.
Then you turn around and say "but I didn't really mean it". So dump
the mask, and validate a non-masked text box.
Of course you realize the Format property can be used for formatting,
but you need to realize its peculiarities as well (it is a DISPLAY
feature, and does NOT affect the storage of the value).

Play with these concepts some more, and you will be able to find a
happy medium for your app.

-Tom.
Microsoft Access MVP