when i set the datatype of a field name to 'short date', how can i set like day/month/year, rather than it's default month/day/year ?

Thanks

set the Format property to "dd/mmm/yyyy" or "d/m/yy" or "dd/mm/yy"

thx for the tip.

i have tried what suggested, but unfortunately I am having a problem.

in the format i set it to "dd/mm/yy" However, when i am entering a date such as 12/12/88, I am getting the following error:

The value you entered isn't valid for this field.

For example you may have entered text in a numeric field or a number that is larger than the Fieldsize setting permits.

any other ideas are appreciated!

Thanks

You don't say where in the world you are but I suspect your regional settings are incorrect

i have checked the regional settings, but they appear to be correct. The Short Date is dd/MM/yy in the regional settings.

Then provided the field data type is date/time short date setting should reflect the correct display.

thx ppl for your help ... problem solved.