Remove blank lines(records) in VB 6.0 report

[joy_rc]

How can I remove the blank lines in the Report of VB 6.0 ? That is if there is any blank record in a database how can I omit the blank record in the report ?

[Nathan]

not sure if it is possible in the data report but could you check your records when retrieving them from the database? ie. use a where clause to check to see if certain values are null or = "" ?

just a thought...