Is there anything that I can do in Access 2007 for text boxes that will capitalise any entires made? For example the monkeys that have to fill in the first name and surname don't always put a capital letter on the names.
Anyway I can make Access tell them they are being tools and that they have to capitalise it or make Access correct it for them because they are too lazy...?
Thanks guys for the tips - I did follow the article from MS and it worked fine but what I need it to do is to replace what is in the field with the correct capitalisation NOT create a separate column of data.
That depends on how the data is being entered. If it's being entered via a form where you can do some validation before getting into the table, then look at running the code AfterUpdate of the field, or something of that nature. Otherwise look at using the code in the linked article in an UPDATE query instead of a SELECT query.