Does anyone know how to set a format for report on a field to prevent printing any spaces when the value is NULL. I am dealing with title printing. My client keep track of sex of people in their table. The value could be unknown. When they print a letter putting name of people, either 'Mr.' or "Ms.' is printed except when it's unknown. I set vtitle to be Null when sex is unknown. But when Null value is printed, it prints 3 spaces because I put enough spaces to print 'Mr.' or 'Ms.' I want set some format , if exists, to prevent printing those 3 spaces and left justify their names..

Thank you always for your insightful suggestions and hints to help me.

Aiko Ichimura
[EMAIL PROTECTED]
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]

(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE: Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body, place any text to search for.
================================================

Reply via email to