Novice
Windows XP 
Access 2003
I'm trying to compare two string values as part of an IF THEN expression. For some reason it's not working. I'm comparing the ComboBox.Value to a string. From looking at the watch window it returns FALSE, but why?? Everything seems to match up. See the image attached.
Do i need to do some sort of conversion of the ComboBox.Value?? I've tried to CStr it, but that errors out.
Access Developer
Windows 10 Access 2019
What is the "Row Source" property setting o the combo box?
It could be that the combo is retrieving 2 columns of data. The first being a hidden column with a numeric primary key value and the second column being a text value, like someone's name.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Novice
Windows 10 Office 365
Hi Bob,
The row source is a query that returns the name and e-mail of each employee. The combo box is bound to the "1"st column....the name of each employee which is a text field in a table.
Access Developer
Windows 10 Access 2019
Can you show us the SQL statement of the query
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Access Developer
Windows 10 Access 2019
Can you also paste all the code of the sub procedure in a code window here
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
VIP
Windows 10 Access 2007
You have a typo?
Olguin and Olquin
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Moderator
Windows 10 Office 365
Good eye Paul!
Virtually Inert Person
Windows 10 Access 2016
WOW! That is easily missed on my laptop monitor and believe me, I studied those two lines. It's barely discernible even when pointed out. Great catch!
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Novice
Windows 10 Office 365
OMG....that is amazing!! I thought that at first, and thought I for sure had the spelling right. It even deceived my eyes!!
Thanks so much...this was driving me crazy.
VIP
Windows 10 Access 2007
It was the Locals picture that gave it away.Originally Posted by Micron
Plus I have a 17" laptop.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Access Developer
Windows 10 Access 2019
Great spot PaulYou have a typo?
Olguin and Olquin
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Virtually Inert Person
Windows 10 Access 2016
Bob, this will have to do for a LFMAO emoji
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
If statement comparing 2 values
Posting Permissions
Reply With Quote
