Variable type not in list

[marathonlady]

I need to define a variable in VBA as a memo field because the string type won't work due to the length of the field. How do I do this when 'memo'
is not an option in the list?

Thanks in advance.

 

[workmad3]

Do you mean you need a VBA variable as a memo because a string is too small (not sure if this can happen, as I think strings have essentially no upper bound) or you need a db field as type memo, in which case you need to make the change in the table designer for the table, not in VB