Date entry

[kellyd]

Hello


I want to enter a date like 092509 and have the field populate the place holders like 09/25/09. Is it possible and how do I do it?
Thank you
Kelly

[Stanggirlie]

This is just a simple input mask.

1. Open the table that you want to work with, and then click Design View.
2. Select the Date/Time field, and then in the lower section of the design grid, on the General tab, click the Input Mask Build button.
3. This will start a wizard that will easily step through it

Then, once it's done, open your table in datasheet view (or the form) and all you have to type in is 092509 and it'll automatically convert it to 09/25/09.

[kellyd]

Thank you, I understand all of that but the problem I have is the steps when you get to the wizard. maybe you could walk me through that. I keep trying and I am not getting the result I am looking for. Obviously I am doing something wrong.
Kellyd

[Stanggirlie]

After starting the wizard:
1. It'll ask you to select the type of data...choose Short Date

2. Click Next

3. It will then show you the Input Mask and you can choose the placeholder character. I usually choose an asterik - but you can choose what you want.

4. Before clicking next, type an example date in the "try it" box at the bottom. If you type in "09252009" it will place the symbols automatically and it'll end up looking like "09/25/2009" or if you wanted to just put a two digit year, change the input mask to 99/99/00 (take of the ending two zeros) and it'll end up looking like "09/25/09"

5. Once you get the result you want (by using the try it box) click next

6. It'll now ask you if you want to store the data with or without the symbols. In your case, you prolly want to store WITH the symbols (the / symbol).

Then click next and your done. Now in your forms and tables, all you have to type in is "09252009" or "092509" (depending on how you did your mask for #4) and it will display like you want it.