spaces in field names

Results 1 to 2 of 2

Thread: spaces in field names

  1. #1
    Join Date
    Dec 1969

    Default spaces in field names

    Does anyone know how to represent a field with a space in it when using the addnew method.<BR>I have a database that has field names such as &#039fax number&#039 and I am unable to change the field names to solve this problem.<BR><BR>using the addnew method to insert records i.e<BR><BR>objRS.addnew<BR>objRS("Fax Number") = faxnumber<BR>objRS.update<BR><BR>I receive the syntax error with the insert into statement. Does anyone know the code to show the space in the field name. I have tried using objRS.Fields(2).value to no avail.<BR>Your help would be most appreciated<BR>Cheers

  2. #2
    Scott B. Guest

    Default RE: spaces in field names

    Try this:<BR><BR>objRS.AddNew "Fax Number", faxnumber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts