There really isn't a type "Memo" for variables. Just make it a character. I would reccomend storing space(999) to it, or use what ever length you expect for the 999.
>Thanks for the quick reply! I'm not using the scatter command, but it's definitely worth a try. When I declare the variables, I declared them Public and it changed all the data types to logical. I need to change the memo field back to memo.
>
>Thanks again!
>Amanda
>
>>If you are creating the memvar's with a scatter command, don't forget the memo keyword.
>>
>>Other than that, if there is a variable with the same name as the memo field, insert into mytable memvar should try to stuff the value of the variable into the record.
>>
>>HTH
>>
>>>I have a blank form that users enter new provider info into, this form does not have a controlsource. I'm declaring variables and using insert from memvar to insert into my table. My problem is, I have a memo field for users to type notes but the memo field refuses to go into the table. I had to initialize some of the other variables (ie. date, char, etc), so how would I initialize a memo variable?
>>>
>>>Thanks in advance for any help!!
>>>
>>>Amanda Brown
--Todd Sherman
-Wake Up! Smell the Coffee!