Compare String not working - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Compare String not working

Kim Wong

2 years ago

I have the following code. It works until I insert the condition for Entity. Entity is a short text field in my table. When I change the Entity field to a numeric field it works. So it looks like i am not coding it properly to check for text field? Its giving me the error: The Object doesn't contain the Automation object...

DMax("[ContractT.ContractID]","ContractT","[ContractT.EmpID]=" & [Forms]![MaintainContractF]![EmpID] & " AND [ContractT.Entity] = " & [Forms]![MaintainContractF]![Entity] & " AND [ContractID] < " & [ContractID])

	Kim Wong OP @Reply 2 years ago

	Sami Shamma @Reply 2 years ago
Can the [Entity] be Null? See: Null Math and Null

	Alex Hedley @Reply 2 years ago
Double Double Quotes

	Kevin Yip @Reply 2 years ago
Hi Kim, what is the complete error message? There should be something at the end: "The Object doesn't contain the Automation object ______"

Kim Wong OP @Reply

2 years ago

Beautiful...double double Quotes worked!!! I knew it was the string match that was not working. I was looking high and low for what was wrong. For a common operation, I couldn't find anything when i googled 'string not matching, etc'... not knowing about double double quotes, that was not my search criteria.

Thanks very much Alex; I was literally spending hours trying to solve it.

This is an awesome forum..thanks everyone!!

	Alex Hedley @Reply 2 years ago
Happy to help. You can do it with single quotes like `". . . Field='" & [Control] & "'"` but then if you have an apostrophe in a word it'll not work so getting into the habit of DDQ is probably a good idea. I always try hardcoding it first then replacing it one at a time to make sure I haven't missed any quotes, it can get you!

	Kim Wong OP @Reply 2 years ago
DDQ certainly a good practice. The quotes certainly got me -that's a good way of working it. Thanks again!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View