Text Box / Table field charaters

[trawets]

Hi
I was wondering if any one could advise where I am going wrong.
I have a db where the main table has two fields that a set to memo
I also have a form which allows the addition and editing of these
fields, however the max number of characters being displayed is 255. I
require probably double this amount
I have checked my table and they are definitely set to memo,
The data was initially imported from an excel spread sheet and I had
to set the field properties to memo after this.
But I had hoped I would be able to display more that then 255 a text
field offers
even when I now try to add extra text through the text box the data
does not save.

 

[Dale Fye]

1. What version of Access are you using?

2. Have you checked to make sure that what was imported actually contains
more than 255 characters?

SELECT MAX(Len([yourMemoFieldName])) as MaxLen FROM yourTable

3. Are you using the table as the data source for the form you are using
for adding and editing, or are you using a query? If a query, can you post
the query? Any kind of GroupBy or Distinct query that contains a memo field
will truncate memo text at 255 characters.

4. How are you displaying this text on your form? In a listbox? If so,
the list will only display the first 255 characters from memo fields.

HTH
Dale

 

[John W. Vinson]

I was wondering if any one could advise where I am going wrong.
I have a db where the main table has two fields that a set to memo
I also have a form which allows the addition and editing of these
fields, however the max number of characters being displayed is 255.

In addition to Dale's suggestions, make sure that you do NOT have a Format
property defined on the field - in the table, in the form's recordsource
query, or in the Format property of the textbox. Also, don't try to sort by
the memo field (in any of these places). Any one of these will truncate the
text.

John W. Vinson [MVP]

 

[trawets]

1.  What version of Access are you using?

2.  Have you checked to make sure that what was imported actually contains
more than 255 characters?

SELECT MAX(Len([yourMemoFieldName])) as MaxLen FROM yourTable

3.  Are you using the table as the data source for the form you are using
for adding and editing, or are you using a query?  If a query, can you post
the query?  Any kind of GroupBy or Distinct query that contains a memo field
will truncate memo text at 255 characters.

4.  How are you displaying this text on your form?  In a listbox?  If so,
the list will only display the first 255 characters from memo fields.

HTH
Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

Hi
I was wondering if any one could advise where I am going wrong.
I have a db where the main table has two fields that a set to memo
I also have a form which allows the addition and editing of these
fields, however the max number of characters being displayed is 255. I
require probably double this amount
I have checked my table and they are definitely set to memo,
The data was initially imported from an excel spread sheet and I had
to set the field properties to memo after this.
But I had hoped I would be able to display more that then 255 a text
field offers
even when I now try to add extra text through the text box the data
does not save.- Hide quoted text -

- Show quoted text -

Hi dale
Thanks for your quick response
1 2003
2 Yes defintly
3 direct data source
4 The form says they are text box

Even when I try to update the table feilds manually, it does not
accept any more data, so I suspect it has more to do with the table,
than the form. But I have checked again and it says memo in the
properties.

After to reading your post I have been playing around, I inserted
another field and set it to properties to memo, added another text box
to my form with a direct access to the form added more than 255 in the
table manually and bingo showed this in text box in form.
I am comfused

 

[trawets]

In addition to Dale's suggestions, make sure that you do NOT have a Format
property defined on the field - in the table, in the form's recordsource
query, or in the Format property of the textbox. Also, don't try to sort by
the memo field (in any of these places). Any one of these will truncate the
text.

             John W. Vinson [MVP]

Hi John
I was writing the other reply so I missed your post
but your bang on the format field it wasnt blank
that has done the trick, must have picked it up on import of data
thanks again guys for all your answers
stewart

 

[Dale Fye]

John,

Is "format propety thing" related to the 2003 SP3 bugs? If so is it
resolved by the hotfix?

Did not realize that including the memo field in the sort would do this as
well, probably because I have never thought to try it.

Learn something new every day.

--

email address is invalid
Please reply to newsgroup only.

 

[John W. Vinson]

Is "format propety thing" related to the 2003 SP3 bugs? If so is it
resolved by the hotfix?

Nope. It's been a problem since Access 2.0. Sort of in the nature of the
beast; specifying a Format property requires (in principle) that the entire
field value be "looked at" or processed, and a Memo could contain a billion
bytes of data - so the Access developers evidently just decided "nope, no way,
just do the first 255 bytes and leave it at that".

Did not realize that including the memo field in the sort would do this as
well, probably because I have never thought to try it.

Same problem - an Index entry can't contain a gigabyte for each record, and a
memo field (again, in principle) could.

John W. Vinson [MVP]