Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Any way to have long text (memo) parameters in DAO and MS Access?

I've searched all over for information on this, and it seems like DAO paramaters in Access are restricted to 255 characters.

Really? Still? Even in Office 2010? It seems absurd. I'd prefer not to switch to ADO, but at this point it seems like I'll have to.

Is there any way to work around this while still using DAO and VBA code?

And are there any methods at all that allow using named parameters in queries that are over 255 characters in length, DAO or otherwise?

like image 464
jeremiahs Avatar asked Aug 23 '12 23:08

jeremiahs


People also ask

What is the maximum length a text field in access can be?

Short Text In Access web apps the Short Text field is set to store 255 characters by default, but you can adjust the Character Limit property all the way up to 4000 characters.

What is the storage size of Memo and text data type in MS Access?

The Text data type is used for short text fields of limited length, and can contain up to 255 characters. A Memo field is a virtually unlimited text field. It can store up to 1GB of text.

How do you create a Memo field in access?

Right-click the column to the right of the position where you want to add the new Memo field and select Insert Field. Select the field and click the Fields tab. Click More Fields and select Memo . Double-click the header row and enter a name for the new field.

How can you view the entire data of Memo field?

While in the text box hold SHIFT down and press F2.


2 Answers

Your choice is dynamic sql, a recordset or ADO, I am afraid.

Access Specifications 2010

And it's the same for 2013 as far as I can tell from a test.

like image 183
Fionnuala Avatar answered Sep 27 '22 23:09

Fionnuala


I've done sometime in access 2000 this including the contents of the memo field inside the sql statement, not as a paramenter. In order to do this, I had first to preprocess the memo field to duplicate each " inside the memo.

Hope it helps.

like image 25
FGM Avatar answered Sep 27 '22 22:09

FGM