Input mask

  • Thread starter Thread starter aviscomi
  • Start date Start date
A

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?
 
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
 
Back
Top