Simple report question-eliminate the empty box!...CANT GET IT RIGHT!

[robert]

This is mucho simple, but my even more simple mind cannot get it to
work, here is the situation: my report lists 3 things, name, company,
location like this:

Robert
ABC Company
City, State, Zip, Country

Then the next name starts, one person got fired or quit and doesnt have
a company name any more, the result is:

Robert

City, State, Zip, Country

How the H(you know what!) do I get it to read:

Robert
City, State, Zip, Country?

I'm using 3 separate text fields with only the column name or:

[reportNAME]
[reportCOMPANY]
[reportLOCATION]

SOMEONE PLEASE HELP, they are all text fields in the database,
yes=Unicode compress, allow zero length.......no=required, indexed, I
had the fields set to allow shring and grow.

Thanks in advance.

 

[Rick B]

Squeeze all the fields to be only one pixel high, then set the "can grow"
property to yes.

Or leave them as is and set the "can shrink" to yes.

Or put all in one field with carriage returns...

= "This is line 1." & chr(13) & chr(10) & "This is line 2."

 

[Rick B]

Oops...
Option three will not work. It would leave a blank.

Change it to...

= ("This is line 1." + chr(13) + chr(10)) & ("This is line 2." + chr(13) +
chr(10)) & ("This is line 3." + chr(13) + chr(10))

--
Rick B

Squeeze all the fields to be only one pixel high, then set the "can grow"
property to yes.

Or leave them as is and set the "can shrink" to yes.

Or put all in one field with carriage returns...

= "This is line 1." & chr(13) & chr(10) & "This is line 2."




--
Rick B

This is mucho simple, but my even more simple mind cannot get it to
work, here is the situation: my report lists 3 things, name, company,
location like this:

Robert
ABC Company
City, State, Zip, Country

Then the next name starts, one person got fired or quit and doesnt have
a company name any more, the result is:

Robert

City, State, Zip, Country

How the H(you know what!) do I get it to read:

Robert
City, State, Zip, Country?

I'm using 3 separate text fields with only the column name or:

[reportNAME]
[reportCOMPANY]
[reportLOCATION]

SOMEONE PLEASE HELP, they are all text fields in the database,
yes=Unicode compress, allow zero length.......no=required, indexed, I
had the fields set to allow shring and grow.

Thanks in advance.