Date Field Display Problem

[sunwindandsea]

I'm having trouble displaying a date on a form that cannot be edited. I used the "=" function to do this for other fields that are displayed at the top of each page, such as, lastname, firstname middlename, etc.

When I use "=datefield" #Error is displayed in the Form View, likewise # Error is displayed in the Form View if I use "=FORMAT([datefield], "yyyy-mmm-dd')

How can I display a date field on some pages/tabs of form that cannot be editd by the user. Users can edit the datefield on the last page/tab of the form.

Thanks,

Ed

 

[dhookom]

You can't have a text box with a control source beginning with "=" and a name property of an actual field name. What are your field name and control source properties?

Duane
Hook'D on Access
MS Access MVP