Format Time (1 Viewer)

[Bechert]

Hello group,
Medical insurance (in the US) requires a date/time stamp message when an electronic signature is used on a report: "Electronically signed by Jane Doe 7/10/2015 10:05 PM". The message is in an unbound control on the report. When a user does not have an electronic signature only their name is displayed. The date/time is retained with the record.

When I use Format(Now, "mm/dd/yyyy hh:nn A/P") I get "07/10/2015 10:05:00 PM".
The input mask in the table and the control on the form for this field is "mm"/"dd"/"yyyy h":"nn "A\M;;_

How do I get rid of the seconds (":00")?

Thanks,
Bill

 

[vbaInet]

You have a lot of formatting and one of them is causing a conflict. First of all, remove any formatting/input mask at table level.

 

[Bechert]

Thanks, VbaInet but removing the input mask from the table did not help.
I then tried adding the input mask on the control but that didn't work either.
Then with no input mask in the table or on the control I removed the "AP" Format(Now, "mm/dd/yyyy hh:nn") with the same result.

Any other ideas?
Thanks,
Bill

 

[vbaInet]

Upload a cut-down version of your db (i.e. just the form and the table) including some fictitious test data, and I'll have a look.