using field name as a value

I want to be able to put IF statements in my codes, that say

"If field name 1, then:"

I want to do this while I am looping through all the fields with

For Each fld In myrecord.Fields
Print #filenum, fld.Value;
Next

Of course, I'd want it to be before the Next command. my goal is to print characters when things equal a certain field of the table.

Thanks guys,

Let me know.

i don't follow what you are trying to do. could you explain more?

you can do:

I am trying to print some text to file while printing the fields to file. For example, field1, field2, and field3 are my fields. I want to print

Field1 ----^^^text here^^^----Field2----^^^Text here^^^----Field3.

Why can't you do the following:

For Each fld In myrecord.Fields
Print #filenum, fld.Name & "---"
Print #filenum, "put your text here"
Next

Sorry,

I was just using that as a generalized view of what I'm doing. The text betweem each of these fields will be different, but consistant through records. There will not be the same text between the first and second field, as there is between the 5th and 6th.

But you may use select/case statement:

For Each fld In myrecord.Fields
Print #filenum, fld.Name & "---"
select fld.Name
Case "MyMoney"
Print #filenum, "my money"
case "UncleMoney"
Print #filenum, "my future money"
end select
Next