Non-editable field

  • Thread starter Thread starter Guest
  • Start date Start date
In
Klatuu said:
For example, had the OP used the very common txtDate, the
problem would not have happened.
Click to expand...

Au contraire. If the control were named "txtDate", but the field named
"Date" were still in the form's recordsource -- whether the control were
bound to that field or not -- the problem would still have occurred.
You'd still need to refer to VBA.Date to keep Access from understanding
"Date" as the field. Without any qualification of the name, Access will
find the field and control objects before the VBA function. So reserved
words shouldn't be used for control *or* field names.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word 2007 Creating Forms 1
Access Open Form with WhereCondition 6
Simple IF THEN to Populate a Form Field 5
Create Fillable PDF Forms With LibreOffice Writer 3
Read-Only for Forms after all fields are completed 10
Copy record info into new form 0
Form Suddenly Became Non-Editable? 1
Access Form - Lock Fields from Editing 0

Back
Top