Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reference a field name with spaces in recordset

Status
Not open for further replies.

storm75m

Programmer
Apr 18, 2001
81
US
Access 2k, Windows 2k, DAO or ADO question
How do you reference a field name that has spaces in a recordset? Ex:

With rs
duedate = !Due Date
end with

This returns an error, and I'm sure it's because of the spaces in the "Due Date" field name. Please help with correct syntax, thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top