Invalid use of Property MS Access 2010

[Sherianmartin]

Hi, I'm trying to assign a value to a field. eg

Me.pcmammogram-confirmed = "Yes"

. However after I click or attempt to write somewhere else the system puts a space between the field. See below:

Me.pcmammogram-confirmed = "Yes" (this is how its written)
Me.pcmammogram -confirmed = "Yes" (This is how it looks

then I get this error: "Invalid Use of Property".
Please help! Thanks.

[kthprog]

try

[Me.pcmammogram-confirmed] = "Yes"

Sometimes this works for normally invalid field names.

It's adding that space because it thinks the "-" is subtraction.

I'm assuming this is VBA.

[zmbd]

1)

• Access 2007 reserved words and symbols
• AllenBrowne- Problem names and reserved words in Access

2)kthprog - invalid field names - hit it on the head.

3)Please use the [CODE/] button to format posted script and formated text - Please read the FAQ

[NeoPa]

Z
"kthprog - invalid field names - hit it on the head."

He did, but unfortunately the example fix he posted wasn't quite correct. Try instead :

Me.[pcmammogram-confirmed] = "Yes"

Now consider a couple of other issues.

1. The item you refer to as a field is actually a control. Not too important but it helps when trying to communicate.
2. Naming of items is much better done without using invalid characters where possible. The minus (-) is not recommended for use in names for the fairly obvious reason that it can easily be misunderstood.
   Also, if the name is PC Mammogram Confirmed, then this is much easier to read if you use capitals in the right places. Consider a name of PCMammogramConf irmed.
3. If the field that the control is bound to is a Boolean field (One that takes Yes/No; True/False etc.) then assigning a string value to it, as your code showed, will not work as expected. In VBA a True value is written as True without any quotes.