Re: us date format

Bob Wickham wrote:
>I have a form where the user enters a date in each record.
>In many records the date stays the same so I have written the following
>code that inserts the previous records value into the current record.
>
>Private Sub PaymentDate_AfterUpdate()
>
> Me![PaymentDate].DefaultValue = "#" & Me![PaymentDate] & "#"
>
>End Sub
>
>Works OK, except when the value is inserted it displays as US date mm/dd/yy.
>I'm typing dd/mm/yy in the first record
>I live in Australia and want it to appear as dd/mm/yy in the next record.
>
>I believe I need to convert the date to a number with CLng but I've
>tried all sorts of ways and cant get it to happen.


I think all you need to do is set the text box's Format
property to:
dd/mm/yy

--
Marsh
MVP [MS Access]
.