Greetings,

I've used the IsDate successfully to check if a date within a text box is
valid.

When you enter the textbox the date is set to todays date and formatted
dd/mm/yyyy
txtDateAdmitted.Value = Format(Now, "dd/mm/yyyy")

However I would like to be flexiable and allow the user to enter date in any
format and then later apply the formatting of 'dd/mm/yyyy'
So far I have done this aslong as ISdate(textbox1.value) returns TRUE.

However to be more efficent how do I check the ISDate and the format is
dd/mm/yyyy ??

I've tried below but its syntically incorrect.

ElseIf IsDate(txtDateAdmitted.Value) And Not Format(txtDateAdmitted.Value,
"dd/mm/yyyy") Then

Cheers
Rob W