Masks

  • Thread starter Thread starter Reggee
  • Start date Start date
R

Reggee

I'm setting up a database for our company, and right now
I'm trying to make a work order form.
Our job order numbers look like this:
"1103-001" I've got the mask to look like this ####\-###
So, when I'm inputing the number the dash is there, but
when I click onto the middle or footer, the dash
disappears. Anyone know why?
I've gotten it to work on a different form, but so far as
I can tell, I did everything the same on both, yet for
some reason it's not working on this one.
Any help would be appriciated.
 
The input mask property has three sections, separated by semicolons:

1) The mask
2) An optional indicator to include any literal characters. Set this to 0
to include the dash in the stored value. The default value is 1 - do not
store the characters.
3) The fill character

So, change your mask to

####\-\###;0

You'll have to re-edit the values already saved.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411
 
Back
Top