Needing a access report to captilize mutiple fields

[danny]

here's the problem, we have a report that is in colums that has the same
duplicate fields listed. In the first data field of Rank (this is a military
file) we can use the > symbol to force the report to captilize the data in
that field, but the other fields that a use the same data field will not
print upper case. any ideals

thanks danny

 

[Marshall Barton]

here's the problem, we have a report that is in colums that has the same
duplicate fields listed. In the first data field of Rank (this is a military
file) we can use the > symbol to force the report to captilize the data in
that field, but the other fields that a use the same data field will not
print upper case. any ideals

As long as the text is less that 255 characters, the >
Format should work in any text box.

 

[Larry Linson]

here's the problem, we have a report that is in colums that has the same
duplicate fields listed. In the first data field of Rank (this is a
military file) we can use the > symbol to force the report to captilize
the data in that field, but the other fields that a use the same data
field will not print upper case. any ideals

You could, if you prefer, create an Update Query, and use the StrConv
function to update the Rank Field to vbProperCase. All the US military
ranks that come immediately to my mind have each word capitalized: Master
Sergeant, First Lieutenant, Major General, Chief Warrant Officer, etc. Now,
however, if you have abbreviations such as T/Sgt, M/Sgt, or SCWO. you may
still have to do some manual cleanup, or do another query that treats them
as special cases.

If you put the ranks in a Table, and have them chosen from a Combo Box,
rather than letting someone type in whatever seems appropriate, you can
control the data in the future, after you "fix" it.

Larry Linson
Microsoft Access MVP