Masks

[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.

 

[John Viescas]

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