Writing letters using reports

[paul123456]

I am having a big problem that i just noticed. I have about 2000 record in my dbase I am using reports to print letters with these records. the problem is is that before i had the city, first name, middle, last name field with the no input mask. and now i want all of those fields to be all caps. with the >L??????? as the input mask. it looks fine in the table and all of the fields are caps but when i run a report the fields are the way the originally were. with some lower and some higher. how can i have these reports print and view with all caps? what will i have to do? Thanks, PAUL

 

[KenReay]

Hi

Several ways to solve this

You could run an update query:

UPDATE MyTable SET City = UCase(City);

Or

In the Control source on the report, instead of binding to City, put =UCase(City)

Or in the query on which the report is based, put a calculated column so:

CityU:=UCase(City) Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[scriverb]

Paul, you have posted your problem in a slightly different manner twice in the same forum( see thread thread703-482535). We enjoy providing assistance to you but don't have us doing double duty to solve the same problem. You will see that I responded to the other Thread with a similar response saying that you needed to write and execute an Update query to fix the 2000 records.

Please be more considerate with future questions. Bob Scriver

 

[paul123456]

I have another question that i can't figure out. I am writing a letter as a report and in one on my sentence a specific field needs to be bold. it there a way i can do this? i didn't want to split the sentence up because i think it would look unprofessional. For exp hear is a sentence.

="Dear so and so we have recieved something from your last know address which was once " & [address] & ". please get back to us asap."


i wanted to bold just the address how would i do this without effecting the entire sentence? Thanks, PAUL

 

[KenReay]

Hi

Cannot do this as standard, except by splitting the sentance, see

http://www.lebans.com,

you might find something there to help Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK