asked on

Access Form - Short Date Format - Unbound Box

I have created an access form - with the outbound box formatted to be short date - which I will later then base a query on to retrieve these dates.

However, when I am in form view, I do not see the "/" as day, month, year separated for the user to clearly see where the separation occurs.

Thank you

Rey Obrero (Capricorn1)

do you see a calendar on the right of the textbox when you click on the textbox?

try, doing this
in the design view of the form, select the unbound textbox then hit F4
select the Format tab
set the Format to Short Date
set the Show Date Picker to For dates

see how it goes..

exp vg

ASKER

Thanks - it was already set "For Dates"

Unfortunately I do not see the "/" still. I thought these would appear automatically.

I do see the calendar to the right of the box as well.

Rey Obrero (Capricorn1)

oh. you mean the mask? i suggest not to use it.
just use the calendar to pick the date..

exp vg

ASKER

Do you know where the Mask is so if I choose to use it I can? I can indicate instructions that the user selects dates from the calendar.

Thanks.

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION