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!
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!