I am working on a glossary of terms and am trying to create a report that will contain a list looking something like this:
Code:
term, subject
This is a long description for the term
See also: term1, term2
I know how to set the font format to italics, but am having difficulty with line 1 because the fields are of fixed length. I want the length to be automatically determined according to the length of the actual content of the database field so that there is no gap between the text and comma and the subject field. I would also like to add a comma or possibly brackets around the subject text e.g.:
Code:
term (subject)
This is a long description for the term
See also: term1, term2
but can't find how to do this. Its been a while now since I used MS Access for anything an it has changed significantly. I did find properties called Can Grow and Can Shrink and both are set to yes, but both fields still appear of fixed length.
In the meantime I am working on trying to figure out how to make the 'See also' line appear only when the field in question is not empty. If anyone can help me with the above it would be appreciated.