First Letter of Word to upper case

arnelgp · Aug 12, 2020

you have Combobox there and the Rowsource is missing.
try.

theDBguy · Aug 14, 2020

Pat Hartman said:
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:

Pat Hartman said:
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:

Pat Hartman said:
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."

Gasman · Aug 14, 2020

My download had a > character in the format property of the table?

theDBguy · Aug 14, 2020

Gasman said:
My download had a > character in the format property of the table?

@Gasman If you're talking to me, because I said "there was nothing in the Format property of my experimental table," I was referring to the table I created in post #15.