Formating date to short date

[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

 

[Rick Brandt]

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

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?

 

[Pete Provencher]

I used the mask wizard and used 99/99/0000;0;_ as the mask.

Pete Provencher

 

[Tim Ferguson]

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.

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

 

[Pete Provencher]

Thanks for the info.

Pete Provencher

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