Recent content by Doctorswamp

Have simple continuous form to create a pick list. One combo field looks up products from a list of about 5000 items. Even though the combo homes in as letters are typed there is still a lot of typing needed to identify the target product. This is because many products have the same 10 to 15...

Mark That's just great, thanks. Sorry to be slow to respond, few days hols.

Hi guys What I'm after is to convert 'john smith' or 'JoHn SmItH' into 'John Smith'. And if there are other options for the final format they might be useful too.

Hi Is there a way of changing the case of text that has been entered in a table? Want a form to display capitalised names, say, no matter how they were entered. Know that they can be displayed in all caps using >. Thanks