You set a format on the table. Remove the mask and then open the table. Do you see upper or lower or more likely a mix? In my opinion, you should NEVER, EVER put a format on a table column. All that does is to hide the actual contents of the table. Format the output if that is what you want or format the data before it is actually saved using either the control's AfterUpdate event (you can't change data using code in the control's BeforeUpdate event) or using the form's BeforeUpdate event.
I'm sure you've seen lots of posts about date issues. A common cause is using Now() to save the date and not knowing you have a time component that is making your search not work because you have formatted the column in the table to not show time.
@Pat Hartman, I removed the Input Mask and the data in the table showed "a" and "A," just as the result of the DLookup() calls indicated.
Just to make sure we are on the same page, I am talking about the
Input Mask. I am getting the impression that you're talking about the
Format property, based on this comment:
You set a format on the table.
Just to clarify, there was nothing in the Format property of my experimental table.
My little experiment was triggered by your previous comment, such that:
Just FYI, Input masks do not change data.
And all I was saying was when I entered a lower case "a," the Input Mask
changed that data into an upper case "A."