Formatting Time in Labels

  • Thread starter Thread starter Mary23
  • Start date Start date
M

Mary23

We are trying to make labels drawing from a table that contains appointment
times. In design mode for the table, we have formatted the field to display
in "Medium Time" (i.e. 8:30 AM). However, when we create the labels, the time
still appears with the seconds displayed (i.e. 8:30:00 AM). Why wouldn't the
formatting carry over?

Any suggestions would be greatly appreciated.
 
Formating just does not carry, only data. You need to format in the report.
The same for sorting, you have to use the report Sorting and Grouping.
 
As Karl points out, the formatting doesn't carry over.
The Format you impose on a table field has no effect on how the data is
stored, only how it is displayed on forms. IMHO, it is better to leave the
Format alone at the table level and do your formatting at the form and report
level.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Datedif Expression 1
Need Help with Time Format 3
Datediff Function 1
Time format in GridView 5
Combobox time 3
Formatting short times 2
Subtracting time...again 2
Expressions in a form 2

Back
Top