I hope someone can help me, I'm not a coder but many moons ago learnt Access from college course. I'm currently trying to refresh my knowledge from that time ago and started building a database (Access 2019). The problem I have is to do with a form field data entry for text 'Supplier:', it must allow more than one word i.e. two or three words.
I want each the first letter of each word to start with an uppercase and then continue with lowercase using a space to break for the following word and so on to change after tab to the next , I've looked at input masks but I don't think it will do what I want.
Any ideas on a piece of code, and where do I put it?
Many thanks
Mike
I want each the first letter of each word to start with an uppercase and then continue with lowercase using a space to break for the following word and so on to change after tab to the next , I've looked at input masks but I don't think it will do what I want.
Any ideas on a piece of code, and where do I put it?
Many thanks
Mike