I have a linked SQL table with a StartTime and EndTime that are time(0) formats. In Access, I have a continuous form listing records with these times. These times will show up as “hh:nn:ss”. I would like to format these time fields so they show up as “h:nn:ss AM/PM” and still allow it to be edited. As far as I am aware, using Format() on these will prevent any changes from occurring.
My thought of approaching this was to have the StartTime/EndTime fields hidden,… Read More