i have a field, FamOrTreat, in a report. the value for that field can either be "Family" or "Treatment." to save space on the report, i want it to show up as either "T" or "F" rather than the whole word.

i know this is probably very easy, but i have no idea how to achieve it.

help would be much appreciated. thank you.

In the control souce put:

= Left([FamOrTreat],1)

GumbyD

thank you.

it wouldn't work as the control source on the report, but i made a field in the underlying query based on your help. that worked just fine.