Changing all text on all Reports to vbUpperCase with a Public Function 1

[ImStuk]

Is there a way to write a public function that will output all reports to vbUpperCase? I have several reports on a Database that, because of poor user data input, look horrible. I want to set every text box on every report to Upper Case without having to go through and change each text boxes InPut mask on every report in the database. I did not design this database, but have been asked to try and make our invoices and work orders etc...look better.

 

[67peshawar294]

Hi stuck,
If there aren't "too" many fields it might be easier to; in the format section of each textbox you want ucase just place a
>
Or you can do the same thing in design view of the table.
That will force uppercase in the text box.
jim

 

[ImStuk]

Thanks for the reply. It looks like I am going to have to do that. The problem is there are 50+ different reports. It is a simple DB with many, many reports. At this Point I have already fixed the forms so that everything entered from this point on is Upper Case, but I was looking for an easy way to fix the old data. Thanks for your help.

 

[PWise]

why don't you run a update query on the tables
update tablename set [fieldname]=ucase([fieldname])

 

[ImStuk]

Great Idea pwise, thank you.