Input masks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Annie - 09 Feb 2005 18:59 GMT

Hi. I'm a little freaked out- I just realized that all
of my dates are "backwards": 18/07/1999 rather than
07/18/1999 (July 18th). Yes, I know.

Can you please show me what input mask I need to use to
get what I want? I couldn't find it from the Input Mask
Wizard and don't understand how to create my own.

I'm a little panicked. Thanks, Annie

Reply to this Message

Lynn Trapp - 09 Feb 2005 19:59 GMT

Annie,
Your problem MAY lie in the Regional Settings for your computer, rather than
in Access. Check to see if the date format there is set to dd/mm/yyyy.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> Hi. I'm a little freaked out- I just realized that all
> of my dates are "backwards": 18/07/1999 rather than
[quoted text clipped - 5 lines]
>
> I'm a little panicked. Thanks, Annie

Reply to this Message

Annie - 09 Feb 2005 20:18 GMT

Lynn,
You are FABULOUS! Thank you- I thought I was losing my
mind. But that sloved my woes and now I can see if wrote
my reports correctly.
Annie

>-----Original Message-----
>Annie,
[quoted text clipped - 12 lines]
>
>.

Reply to this Message

Lynn Trapp - 09 Feb 2005 20:55 GMT

Thanks! I'm glad that worked. :-)

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

> Lynn,
> You are FABULOUS! Thank you- I thought I was losing my
[quoted text clipped - 22 lines]
>>
>>.

Reply to this Message