Change Case

[mattbryant4]

The database field i am looking to bring into my report is in lower case, is it possible to change the data in the report to be upper case leaving the data in the table in lower case?

 

[MisterMo]

UpperCase{MyTable.MyFile}

Mo

 

[mattbryant4]

I cant get this code to work, i enter the field i want to be in captials where it says {mytable.myfile} and it comes up with a error saying "the remaining text does not appear to be part of the formula"

this is what my code is:
Uppercase{tblTasks.ShortName}

 

[MisterMo]

sorry my fault

Uppercase({tblTasks.ShortName})


Mo

 

[mattbryant4]

Thank you it works Yay