Formating date to short date

  • Thread starter Thread starter Pete Provencher
  • Start date Start date
P

Pete Provencher

Using 2000:

Trying to display just a short date in a date field. It is now showing date
and time. I changed the field format to short date and even change the mask
to short date but it is still displaying both date and time.

Any help appreciated.

Pete Provencher
 
Pete said:
Using 2000:

Trying to display just a short date in a date field. It is now
showing date and time. I changed the field format to short date and
even change the mask to short date but it is still displaying both
date and time.

Any help appreciated.

Pete Provencher
Click to expand...

Format will not change what is displayed when the control has focus, but it
should change when you leave the control. A mask however should work even
when the control has focus. I suspect you didn't set the properties the way
you think you did. What specifically did you enter for the InputMask?
 
Trying to display just a short date in a date field. It is now showing
date and time. I changed the field format to short date and even
change the mask to short date but it is still displaying both date
and time.
Click to expand...

Input masks have no effect on data display (nor on data validation,
either). They are just there to annoy the users.

You need to change the Format property of the control that is displaying
the value (i.e. a text box on a form or a report). If the user has set up
his or her Control panel to show funny formats, then that is what you get
when you use the named formats. If you want real control, then use the
explicit format strings like "dd/mm/yyyy".

Hope that helps


Tim F
 
Thanks for the info.

Pete Provencher
Tim Ferguson said:
Input masks have no effect on data display (nor on data validation,
either). They are just there to annoy the users.

You need to change the Format property of the control that is displaying
the value (i.e. a text box on a form or a report). If the user has set up
his or her Control panel to show funny formats, then that is what you get
when you use the named formats. If you want real control, then use the
explicit format strings like "dd/mm/yyyy".

Hope that helps


Tim F
Click to expand...
 
Back
Top