C
Colin Small
Does anyone know why this is going wrong?
I want time values in a textbox to show on a form/report with two digit
hours and the format is supposed to be hh:nn (input mask is blank). Access
2003 immediately autocorrects "hh:nn" to "short time", which doesn't use the
leading 0. I can workaround on reports using =format(time,"hh:nn"), but
this is inconsistent with the form where the data is entered. and really
messes up when conditional formats are used!
I also tried hh:nn;hh:nn, which isn't "autocorrected", but the result is the
same - e.g 1:30 not 01:30. It shows that the autocorrect feature isn't the
problem.
Colin
I want time values in a textbox to show on a form/report with two digit
hours and the format is supposed to be hh:nn (input mask is blank). Access
2003 immediately autocorrects "hh:nn" to "short time", which doesn't use the
leading 0. I can workaround on reports using =format(time,"hh:nn"), but
this is inconsistent with the form where the data is entered. and really
messes up when conditional formats are used!
I also tried hh:nn;hh:nn, which isn't "autocorrected", but the result is the
same - e.g 1:30 not 01:30. It shows that the autocorrect feature isn't the
problem.
Colin