Microsoft Access: “Make-Table Query” Force Memo Fields
by SLeepdepD on Oct.05, 2010, under Programming
Unfortunately it looks like there isn’t a way to force Access to make a table with Memo data type fields instead of Text. A functional work around is:
- Run the Make-Table query
- Edit the table in Design View
- Change the Text field to Memo
- Change the Make-Table query to an Append query
- Create a Delete query
- Run the new Append query
(No Ratings Yet)
Loading ...
May 8th, 2012 on 9:58 AM
Thanks for this… Was struggling for an hour or so trying to figure out how to get my memo fields to work!