Input mask

[aviscomi]

I want to force the user(s) to enter a value in the following numeric
(double) format:
#.###
Example: 2.358
These values are for a gasoline survey and I don't want to worry about
cleaning the data for an obscure double digit value.

Is there a way to force my data entry people to do this?

 

[ruralguy via AccessMonster.com]

Have you looked into Input Masks? It is in VBA Help.
Maybe 0.000

 

[missinglinq via AccessMonster.com]

And if you go the Input Mask route, be sure in use this to assure that if
they click on the textbox the cursor will go to the beginning of the field.
Otherwise the insert point will be wherever they clicked in, and they'll
waste time redoing it!

Private SubYourControlName_Click()
Me.SSN.SelStart = 0
End Sub

If your default for entering a field is set to anything other than "Go to
start of field," also use this

Private SubYourControlName_GotFocus()
Me.SSN.SelStart = 0
End Sub

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com