Time format Error?

[Hmadyson]

I am trying to format a text box to show a date as mm/dd/yy hh:nn:ss where each piece of the date has 2 characters. The problem that I am running into is that a lot of the data in the field is just a date and does not have a time portion added. I would like to show that as mm/dd/yy 00:00:00, but by putting the following format in mm/dd/yy hh:nn:ss I get mm/dd/yy 0:00:00 this is throwing all of the lining up off. Does anyone have any suggestions on how to work around this, or what I may be doing wrong? Thanks.

 

[Aivars]

Apparently table field format is "Short Date" but if you want to show date with time you may set field date format "General Date".

Aivars

 

[Hmadyson]

Everything worked fine once I changed my default PC date, but I am not just creating this database for myself and I want it to override the settings on other PCs.