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.
 
Back
Top