permissible characters
thanks fredg & John for the sound advice! Becky
"fredg" wrote:
On Tue, 6 Apr 2010 15:10:01 -0700, Becky wrote:
Newbie question: exactly which characters may be used in names of a) tables,
forms, reports,...? b) mdb file names?
TQ
Becky
Access Help is your friend.
Name + Guidelines for naming fields, controls, and objects
Guidelines for naming fields, controls, and objects
Names of fields, controls, and objects in Microsoft Access:
Can be up to 64 characters long.
Can include any combination of letters, numbers, spaces, and special
characters except a period (.), an exclamation point (!), an accent
grave (`), and brackets ([ ]).
Can't begin with leading spaces.
Can't include control characters (ASCII values 0 through 31).
Can't include a double quotation mark (") in table, view, or stored
procedure names in a Microsoft Access project.
Although you can include spaces in field, control, and object names,
most examples in the Microsoft Access documentation show field and
control names without spaces because spaces in names can produce
naming conflicts in Microsoft Visual Basic for Applications in some
circumstances.
When you name a field, control, or object, it's a good idea to make
sure the name doesn't duplicate the name of a property or other
element used by Microsoft Access; otherwise, your database can produce
unexpected behavior in some circumstances. For example, if you refer
to the value of a field called Name in a table NameInfo using the
syntax NameInfo.Name, Microsoft Access displays the value of the
table's Name property rather than the value of the Name field.
Another way to avoid unexpected results is to always use the !
operator instead of the . (dot) operator to refer to the value of a
field, control, or object. For example, the following identifier
explicitly refers to the value of the Name field rather than the Name
property:
[NameInfo]![Name]
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.
|