"Lauren Quantrell" <la*************@hotmail.com> wrote in message
news:47**************************@posting.google.c om...
Thanks for the response.
I'm using no input mask. I have a smalldatetime column (SQL Server
backend) and I need to store date AND time in it. I convert it all to
GMT depending on where the user is, an the table cotains tens of
thousands of records.
Sometimes I need to display it only as a date and drop off the time.
That's where I have the problem with Access showing the time anyway
when the field has the focus.
If you use the format property this is the normal behavior. Display only uses
the format property until the control has focus at which point you see the
actual stored data. If the user does not need to edit the field you can use the
Format Function instead of the format property. If they do need to edit it then
you would have to use a mask. This would set the time back to midnight whenever
they edited the control though.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com