[Domino]

Hi - I'm stuck with something basic. I am using a user-defined data type to define a record (e.g. Customer name, Customer ID). When I put both fields of the record as strings I get no problem writing the record to a direct access file. But when I put the ID as an integer, the file becomes unreadable and data can't be retrieved again.

e.g.

Private Type CustomerType
CustomerID As Integer
CustomerName As String * 10
End Type

Dim Customer As CustomerType

Open App.Path & "\Customers.dat" for Random As #1 Len = Len(Customer)
NumberOfRecords = LOF(1) / Len(Customer)
Put #1, NumberOfRecords + 1, Customer
Close #1


I was advised to convert the text box that contained the customer ID to an integer before assigning a variable to it.....

Customer.CustomerID = CInt(txtCustomerID.Text)

but it didn't help. MsgBox (VarType(Customer.CustomerID)) showed 2, which is an integer. So what is the problem? Why does it write the ID to my direct access file as a square box? Any ideas appreciated, thanks.