DATE

[kealaz]

Can I get access to interpret a 6 number date code and change it to a date?
For example, if I enter 022309 into the field, can I get it to change it to
02/23/09. This is simply so that the user does not need to type the "/"
everytime. Lazy.

Please let me know if this is possible, and if so, how can I do this.

Thank you VERY much!

 

[Gina Whipp]

Kealaz,

You can set the Input Mask property at the table level so the User does not
have to type the forward slashes.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[kealaz]

What would I set the Input Mask property to?

Thank you very much for your help.

 

[Gina Whipp]

Use the wizard (click the elipse button [...]) there is an example...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John W. Vinson]

What would I set the Input Mask property to?

00/00/00

This will make the user type six numeric digits. If you use no input mask at
all you can type 3/2 (three keystrokes) instead of having to type 03/02/09 to
get the same date.