Spaces in object names with code builder

  • Thread starter Thread starter Michael Walsh
  • Start date Start date
M

Michael Walsh

I know it's bad to allow spaces in your naming convention
for objects in Access, but I'm working in someone else's
database who didn't know this.

How can I refer to an item with a space... I have a field
called Contact ID that I want to refer to this way because
there's too many other items depending on finding it named
that way rather than renaming it Contact_ID.

Here's what it looks like now (and it doesn't work)...
Private Sub cmbDefLC_AfterUpdate()
Me!Contact ID = cmbDefLC.Column(1)
End Sub
 
Back
Top