If you post your current code (or at least the gist of it) then someone
might suggest a simple change. Otherwise we have to figure out exactly what
you're doing to the point where we can write a full procedure - not so
simple.

The best I can offer is to suggest testing for null fileds and in those
cases not writing the record to the file....

Regards
Tim

"Brett Smith" wrote in message
...
I am programming a VBA Macro and it is giving me HELL! I basically am
checking through each record and formatting the text in a certain way.
The
text is being exported into a text file and saved in the same directory as
the excel spreadsheet. I used select statements to check through each
record. Each field has a text string before displaying the record. When
the
field is null, the text string shouldn't even show up on the text file.
But,
my problem is it still displays the text string within the text file. How
do
I not display the text string for each field when it is a null field?