i'm new to access: can i use spaces to index a field?

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

Guest

can someone help- i'm new to access and i would like to index company names.
basically can i use spaces in these names, and will the index still work?
 
If I understand correctly... yes, an indexed text field can contain
spaces within the data.
Ex. "Northeast Construction Co." or "

If you're talking about field names in table design, spaces in names are
not recommended. You can use them, but those names will always have to be
bracketed in ANY subsequent code in your application
Ex. [First Name] or [Company Name]
It would be better to use FirstName or CompanyName instead...

hth
Al Camp
 
Yes (to either case; indexes will take care of themselves). If you mean
spaces in the values/entries into the [CompnayName] field, no problem with
normal English spelling. If you mean spaces in the name of the field
itself, that's OK too, but you'll need brackets around it every time you
reference it, like [Company Name]. It's almost always easier and still
readable to NOT use spaces, hyphens, underscores, etc. You can use the
caption property to show your field name as you wish it to appear in
forms/reports.
-Ed
 
Back
Top