write to a variable

[rstout]

I want to write a file to a variable. I have a database the has a record the can only be extracted to a file. I want to extract it to a variable. It has some funky formatting that gets messed when it is put to a file.

vb6

Thanks in advance

[seaweed]

Just set your variable equal to the field value of the recordset object you are using (assuming you're using ADO):

' Assuming your recordset cursor is currently pointing to the 
record you want and the field is called "MyField"
Dim sMyVar as String
 
sMyVar = objRst.Fields("MyField").Value

[rstout]

it is a OCX the connects to Novell's Directoy services and the login script is a stream file. The OCX want to write to a file but I thought a saw a way to create a variable like a file.
I might be thinking of a different function but any help would be greatly useful.