UPDATEFORM: how to use formatting when displaying the values of fields
by Ilona Morison
July 9, 2002 11:24
I am using a UPDATEFORM to check with the user before that information is correct in the database. I am using a date/time field in Access and when displayed in the UPDATEFORM it is displaying the full date/time: eg if I have entered 16:00 in the screen form, I get displayed '1899-12-30 16:00:00'. I have tried usinf the $mid or $right functions but it does not work. Is there a way of filtering this info to display only the correct time (as far as the user in concerned).
Name E-mail optional TopicMessage:
HTTP Link: Link text: