why won't access save short date format I've created?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RichardCP - 27 May 2005 10:32 GMT

I am trying to create tables and forms for my database and have set the input
mask format to short date. Although I have clicked to save, when I open the
form the input mask does not appear. Why is this not being saved? Grateful
for any advice.

Many thanks.

Richard

Reply to this Message

Van T. Dinh - 27 May 2005 10:53 GMT

It sounds like you got confused between InputMask & Format. They are 2
different Properties of the Field (in the Table) and Control (on the Form).

Check Access Help on InputMask and Format.

--
HTH
Van T. Dinh
MVP (Access)

> I am trying to create tables and forms for my database and have set the input
> mask format to short date. Although I have clicked to save, when I open the
[quoted text clipped - 4 lines]
>
> Richard

Reply to this Message

George Nicholson - 27 May 2005 21:16 GMT

Controls on forms only "inherit" the settings of bound fields at the time
you create them. If you make changes to fields in Table design after you
have already created a control for that field on a form, you won't see the
changes on the form. Try deleting the control from the form and add it
again.

HTH,

Signature

George Nicholson

Remove 'Junk' from return address.

>I am trying to create tables and forms for my database and have set the
>input
[quoted text clipped - 7 lines]
>
> Richard

Reply to this Message