Form date format not working

Jaye7

Registered User.
Local time
Tomorrow, 09:11
Joined
Aug 19, 2014
Messages
205
I have a textbox set to a default value of =now()

I have the textbox format set as dd/mm/yy hh:nn

The problem I am having is that the date shows as hh:nn of 00:00, it isn't showing the actually time of say 08:51.

The table field is set to date time.

I have tried =date() and =Today() also and they do not work either.
 
I just tried these

Code:
?now()
17/05/2015 7:01:12 PM 

?format(now(),"dd/mm/yy hh:nn")
17/05/15 19:01
 
thanks, but the date time still shows as 00:00, yet on other forms I do not have this problem, so I am not sure what setting is throwing this specific textbox off.
 
It seems to be because this textbox is bound to a field in the table.
If I remove the controlsource it displays fine.
I checked the field properties in the table and they are set to date/time but only show the date not time.
 
A bound field will get data from the underlying table/query.
 

Users who are viewing this thread

Back
Top Bottom