Format Problem - pull report info from custom time datetime picker

S

Sandy

Hello -

I created two date time pickers on a form; dtpFromDate and dtpToDate. I
wanted a format of 00/00/00 00:00 Am or Pm. On the datetime pickers under
Custom Format, I formatted them as MM/dd/yy h:mm tt.

In the report pulling the info from the form, when I type in the format for
the two textboxes reflecting the datetime pickers, Access changes the format
from the above Custom Format to mm/dd/yy h:nn AM/PM. This displays okay,
except it puts in the seconds also. I don't understand why.

Is there a way I can correct this?

Any help will be greatly appreciated!
 

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

Top