Hi!
I have an access table that I built, but then I needed features in excel so I have now have a spreadsheet link to the table. The data gets entered in an access form. The problem is that when I linked the table and spreadsheet it changed "memo" fields to "text" fields and so when entering the data on the access form you can't enter everything that should go in the memo field. I can go open the excel spreadsheet and enter the rest of the information that will not fit in the form. I'm pretty new at this but was wondering if anyone has come across this before?
Thanks All!
Leigh Ann
I have an access table that I built, but then I needed features in excel so I have now have a spreadsheet link to the table. The data gets entered in an access form. The problem is that when I linked the table and spreadsheet it changed "memo" fields to "text" fields and so when entering the data on the access form you can't enter everything that should go in the memo field. I can go open the excel spreadsheet and enter the rest of the information that will not fit in the form. I'm pretty new at this but was wondering if anyone has come across this before?
Thanks All!
Leigh Ann