Type of Data

[Chi]

Hi,

Hi,

I know that Memo can store up to 65,535 characters and Text can have up to
225 characters.

Is there a way to make the TEXT data type store up to 400 characters?

Thank you
Chi Huynh

 

[Dirk Goldgar]

Hi,

Hi,

I know that Memo can store up to 65,535 characters and Text can have up to
225 characters.

Is there a way to make the TEXT data type store up to 400 characters?

Thank you
Chi Huynh

Actually, a Memo field can hold far more than that, and is only limited to
65,535 if you use a text box to enter its value. The limitation is in the
text box control. And a Text field can hold up to 255 characters, not 225.

No, there's no way to make a text field hold more than that. You'd have to
use a memo field. If you want to limit the memo field to 400 characters,
you could do it with code or a validation rule.

 

[Guillermo_Lopez]

Actually, a Memo field can hold far more than that, and is only limited to
65,535 if you use a text box to enter its value.  The limitation is in the
text box control.  And a Text field can hold up to 255 characters, not 225.

No, there's no way to make a text field hold more than that.  You'd haveto
use a memo field.  If you want to limit the memo field to 400 characters,
you could do it with code or a validation rule.

You can try splitting the Text field in two (200 each). Using code to
split it and when reading it combining them. However, the memo field
is the best option and because it reduces your code input. But it
might make your Database too big if you have to many records.

- GL

 

[Chi]

Thank you for your response!

Actually, a Memo field can hold far more than that, and is only limited to
65,535 if you use a text box to enter its value. The limitation is in the
text box control. And a Text field can hold up to 255 characters, not 225.

No, there's no way to make a text field hold more than that. You'd have to
use a memo field. If you want to limit the memo field to 400 characters,
you could do it with code or a validation rule.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Chi]

I have 15 Question fields in my database. Since the questions are long, the
Text field, 255 characters, can’t store all information. Therefore, I use
Memo instead. But when I ran the report, I got the message like that “The
report is based on a query that exceeds the limit for data in single record."
---------------------

At the beginning, I used Text Data type for all questions. The report works
fine. But after changing them to Memo, I got the message above.

Would you help me please?

Thanks
Chi

 

[Dirk Goldgar]

I have 15 Question fields in my database. Since the questions are long, the
Text field, 255 characters, can’t store all information. Therefore, I use
Memo instead. But when I ran the report, I got the message like that “The
report is based on a query that exceeds the limit for data in single
record."
---------------------

At the beginning, I used Text Data type for all questions. The report
works
fine. But after changing them to Memo, I got the message above.

That's a new message to me. There is a maximum to the number of characters
in a single record in a table *excluding memo and OLE fields*, and I guess
there's a maximum for the size of a record returned by a query, which may
not have that exemption. Was that an exact quote of the error message? If
it was accompanied by an error number, what was the number?

What's the table structure and query SQL for this report? If you have a
table with repeating Question fields (e.g., Question1, Question2, Question3,
.... Question15), you may need to normalize that table a series of records
with fields {QuestionNumber, QuestionText} instead. For survey applications
in general, this is a more flexible format.

 

[Chi]

Thank you Dirk!!

I think that it is hard to continue working on the databse since I made a
lot of errors.

I will make the database simplier. Thank you so much for your patience.
Chi