fields in CR9

[engnouna]

Hi
I have a CR9 with Access Database.The report shows many fields from the database but many of those fields are NULL.So I want the report to only show the fields that contain values.
For example if my report contain the following

Customer(Field heading) Customer(Field value)
If the report does not contain a value of customer,I want to not show neither
Customer(Field heading) nor Customer(Field value)

How can I do it?
thanks

[mabbas110]

Ok , for this goto report then selection formulas then record selection and then write the formula like this

isnull(Fild name)=false

[engnouna]

mabbas110 I didn't catch your proposition
my code is:

Set rep = appl.OpenReport("C:\report4.rpt", 1)
rep.RecordSelectionFormula = "{Btest.BID} =" & nar
rep.ExportOptions.DiskFileName = "C:\report.doc"
rep.ExportOptions.DestinationType = crEDTDiskFile
rep.ExportOptions.FormatType = 14
rep.Export False

where should I place isnull(Fild name)=false?
thanks