Medium time input mask

[Dave Mainland]

Help me,please! I have a field that is formatted in
medium time. When I query the tables to generate a letter
that includes the date and 'time' of an appointment, the
time comes out 10:00:00am. How do I get rid of the two
zeros that represent seconds? I have selected the mecium
time format in the field property box and the data inputs
in the table as 10:00am but the report continues to print
10:00:00am. It is driving me crazy. I changed the
reginal setting for time in control panel to no avail. Any
help would be appreciated.

 

[John Vinson]

Help me,please! I have a field that is formatted in
medium time. When I query the tables to generate a letter
that includes the date and 'time' of an appointment, the
time comes out 10:00:00am. How do I get rid of the two
zeros that represent seconds? I have selected the mecium
time format in the field property box and the data inputs
in the table as 10:00am but the report continues to print
10:00:00am. It is driving me crazy. I changed the
reginal setting for time in control panel to no avail. Any
help would be appreciated.

MailMerge ignores the format settings of your table fields,
unfortunately!

A simple solution is to base the mailmerge on a Query in which you
convert the date/time field to a text string in the desired format,
using the Format() function: put

ShowTime: Format([AppointmentTime], "hh:nn am/pm")

and base the merge on this query.