To enter date data type as dd/mm/yy and dislay as dd-mmm-yyyy

[Harrold]

Hi

I would like to input the date as 25/12/2011 and have it displayed as 25 Dec 2011.

How can i use the expression to show in input mask?

Thanks

 

[Taruz]

Hi..

Properties / format / format = dd mmm yyyy

 

[Harrold]

Hi Taruz,

Thanks for your reply.
But I dont see format in properties sheet.

 

[Alansidman]

You need to make sure that the control (textbox) on your form is highlighted to set the format for it. If you don't highlight it, by default, the properties open up to Detail.

 

[Harrold]

Hi all,

I managed to change the format in form, but the format in table still remain the same if i enter data using table. How can i change the data format in table?

Thanks

 

[Brianwarnock]

Tables are for storing data not for entering it into or displaying it so the format of the table display doesn't matter.

Brian