Access gives me a syntax error every time when a expression contains a comma. For example, using =Left([Country), 3) Access reports omitted an operator or an operand, invalid character or comma, or text without surrounding it in quotation marks. Where's the mistake, I exactly copied syntax from help?
Expression syntax error in the Control Source row
- Thread starter ssh
- Start date
boblarson
Smeghead
- Local time
- Today, 14:27
- Joined
- Jan 12, 2001
- Messages
- 32,059
Check your references in the VBE (Tools/References). See if the Microsoft Common Controls (comctl32.ocx) is listed as MISSING.
When I get an unexplained error on any functions, especially string functions like Left, Mid, or Right, that's the first thing I'll check.
BL
When I get an unexplained error on any functions, especially string functions like Left, Mid, or Right, that's the first thing I'll check.
BL
boblarson
Smeghead
- Local time
- Today, 14:27
- Joined
- Jan 12, 2001
- Messages
- 32,059
Is Country the name of the field or the control? Check to see if your control name is the same as the field name. If so, change the control to something like txtCountry.
If that doesn't work, I'd try importing everything into a new database and see if that helps.
BL
If that doesn't work, I'd try importing everything into a new database and see if that helps.
BL
Wasn't help BUT I accidentally replaced comma with semicolon and voila! All expressions work! And for addition, Access seems not to care about comctl32.ocx. Before semicolon I checked references and Common Controls was disappeared. So, the whole thing was about comma-semicolon? But why? Are expressions dependent on my regional settings? But help gave me comma?
