Primary Key Field has space

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My Primary Key field has a space in it, so whenever I refer to it in VB, it
thinks the second portion is a new argument. I tried changing the field name
to one without a space, but that caused major problems. Please help!!! What
can I do to identify this field in VB?
 
Enclose the fieldname in square brackets. For example:
[Field Name With Spaces]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia


"i_get_weird_assignments_at_work"
 
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

Access Access anti-trim?? 0
Primary Key Field Showing Duplicates 1
Delete primary key 8
Primary Key Value 3
Q for Mr Allen Browne = Auditting a form = Audit Log 1
Tab Key on Primary form with Subform 2
Setting Primary Key on a Linked SQL Table 4
Primary Key info 2

Back
Top