Hi all - forgive me for going off on a tangent from the original thrust of the thread - first post and all. I wish to be able to modify some of the text or formatting as it is being generated - i.e. if a class name field is being filled in with 'R1' I want something that will automatically update to 'Reception 1' when the report prints. Possibly more important and something that I don't know a workaround for - is there a way to change formatting based upon the text that fills a field. If I have a text box and text that is too long for it reports come out truncated whereas I want the box to become larger. Is that part of the property of the text box. Can the first part be done by embedding a macro in the report that runs when it is sent to the printer or saved upon export?
Many Thanks,
Michael
