Thank you. I just was successful by setting VnLine = (Strim(Vtitle))&Fist&Last
I wonder if there is better way to do it although it may have no difference in the appearance. Aiko Ichimura [EMAIL PROTECTED] ----- Original Message ----- From: TOM HART To: RBASE-L Mailing List Sent: Saturday, March 03, 2007 11:53 PM Subject: [RBASE-L] - Re: V 6.5 Try setting a variable=(vtitle&firstname&lastname) and set null = ' ' before printing. There may be an easier way but this is how I have worked around the problem. Tom Hart ----- Original Message ---- From: Aiko Ichimura <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Saturday, March 3, 2007 10:45:00 PM Subject: [RBASE-L] - Re: V 6.5 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]
