Referencing a field with a '_' in it

[Keith]

Hi All

Sorry if this is a really dumb question but I'm quite new to this.

I have a field in my db called "02_Title" (without the " of course).

Now this is not a problem, until I try to call the field to reference it in
a string in the coding of the form.

Example: strSubject = "Item: " & 02_Title & " (# " & ItemID & ")"

Now of course this keeps giving me an error on the _ in the field name.

Is there any way to get around this without changing my field as it is
heavily used in the forms of this DB?

Thanks all

Keith

 

[Andrew Smith]

Enclose the field name in square brackets - [02_Title]

 

[Keith]

Thank you

That worked great.

Keith

Enclose the field name in square brackets - [02_Title]

Hi All

Sorry if this is a really dumb question but I'm quite new to this.

I have a field in my db called "02_Title" (without the " of course).

Now this is not a problem, until I try to call the field to reference it in
a string in the coding of the form.

Example: strSubject = "Item: " & 02_Title & " (# " & ItemID & ")"

Now of course this keeps giving me an error on the _ in the field name.

Is there any way to get around this without changing my field as it is
heavily used in the forms of this DB?

Thanks all

Keith

 

[Allen Browne]

By the way, Keith, the underscore is the reason your field requied square
brackets. It was because the name began with a number.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Thank you

That worked great.

Keith

Enclose the field name in square brackets - [02_Title]

Hi All

Sorry if this is a really dumb question but I'm quite new to this.

I have a field in my db called "02_Title" (without the " of course).

Now this is not a problem, until I try to call the field to reference

it
in

a string in the coding of the form.

Example: strSubject = "Item: " & 02_Title & " (# " & ItemID & ")"

Now of course this keeps giving me an error on the _ in the field name.

Is there any way to get around this without changing my field as it is
heavily used in the forms of this DB?

Thanks all

Keith

 

[Allen Browne]

Yes, Steve. And I see that you had already provided the same information
also.

 

[Keith]

Thanks everyone for your help.

Have got it working now and will bear in mind the naming of my fields in
future.

Keith