Is there a way to have Title Caps? (1 Viewer)

[Brianwarnock]

Should I only insert data from the form view?

Yes, always insert data to tables from a form as that is the place where one can do all the clever formatting, validation, use dropdown lists etc. In the same way all reports are based on queries from the tables rather than the tables themselves, infact the tables sit out of sight as data repositories and access to them is by other objects.

Yes you need an after update event for each text box you wish to capitalise.

Brian

You could probably do them all in the Forms afterupdate event, the difference would be that you would not see any change until after the form was saved or lost focus ie you moved off that form and then back again.

 

[The_Doc_Man]

If you have ONE FIELD that you want to convert for every record in the table, you can do it via an UPDATE query.

In the query design grid view, use the icon in the iconic tool bar to change the query from SELECT to UPDATE.

In the first grid column, select the name of the field to be updated. For argument's sake, call it XYZ.

So the first cell of that grid holds [XYZ]

Now in the Update To row, make it StrConv( [XYZ], 3)

You can run this query as often as needed.

 

[Brianwarnock]

Hi Doc
My little DB had examples of update queries, as well as using a form for new data.

Brian