DateTime InputMask

[Guest]

I have a datetime field on a form with a format of GeneralDate and an
InputMask of
90/90/0000\ 99:99:99\ >LL;0;

My users are just getting used to the idea of entering a time for this field
(we used to only store just the date) so I want them to see the time mask
everytime they are in the field

They can see it in all the following cases:
1. Adding new record
2. Editing an existing record where no datetime data exists
3. Editing an existing record where datetime exists and already
includes time

But they do NOT see the it in the following case:
1. Editing an existing record where datetime exists but does NOT
include time (only a date)

How can I get the input mask to show in this last case?

Thank you in advance for any feedback.

-- JKro

 

[Guest]

My suggestion: cheat. Build an update query to find the records with
the date but not the time stamp. Apply a time of 00:00:00 so that those
records will now come up with the input mask specification on your
forms/reports/stuff. There is probably a more complex or sophisticated
process but I'd need to know more about the application and what you're
trying to do.

Steve in Ohio