Length of text boxes??? 3

[Paladyr]

I have a report that is cutting off the text of the field it is bound to. Is there a maximum size on text boxes because it doesn't look like you can go into properties and change it. I have tried resizing it to no avail. The field it is bound to is a memo field. I have no clue why Access needs a Memo field either. Thanks!

 

[milesada]

check the properties of the text box; specifically "Can Shrink" and "Can Grow"... make sure they're set to "Yes" and see if that doesn't help.

a.

 

[Paladyr]

Thank you for the reply!!! They are both set to yes . Why would microsoft design it this way???

 

[milesada]

heck, why does microsoft do *anything* the way they do?

so - the data type of the field you're linked to is "memo"... does any data in this field get cut short on the report? if so, how many characters display before the cutoff? is it consistent? do you need the field to be memo?

a.

 

[Paladyr]

In the database, the field is not getting cut off. It appears to be consistant, but it is too long to count. It is very small print and about 2 lines with a small amount on the third line. I don't know if it needs to be a memo field. I didn't design this sorry excuse for a database . It was basically designed by someone who knew how to use access without knowing how to program VB or design a relational database so there are a lot of problems . ????? I'll try some stuff in the meantime and report anything i find. Thanks again!!

 

[Paladyr]

Sorry, i don't think I was clear. Only these two text boxes that are linked to memo fields are getting cut off.

 

[Paladyr]

Text boxes max length is 255, so what else could I set this box too?? Am i just out of luck? I think a memo field allows you to enter as much text as you want.

 

[milesada]

memo lets you enter up to 32k of characters. i've never had much luck with memo type data fields - especially if it's a multi-user db. it tends to corrupt *very* easily...

anyhoo - if the length of the text in that field is mostly below 255 characters, you can change the data type to text
w/out losing anything. run a query w/a derived field to find the longest record lenOfData:max(len(FieldName)...

does that help?
a.

 

[Paladyr]

A lot of them are bigger then 255, users basically write out what they did in one day. Since it is a "text box" and a "text field" can only be 255 characters long, perhaps it is only allowing 255 characters to be shown on the report. Yep, just checked it, it cuts off after 255 characters (the text box on the report). Is there another control I could use???

 

[milesada]

i've got a report that has a text box linking to a memo field that has over 2,000 characters in it, and it displays fine... i've got "can grow" set to yes and "can shrink" set to no. can't think of any other settings that would affect it...

a.

 

[CosmoKramer]

Check to see if there is a format for this text box (i.e. a >). If there is, remove it.

 

[BoxHead]

Paladyr,

In one of your earlier posts you say, "Only these two text boxes that are linked to memo fields are getting cut off." What do you mean by linked to?

Be sure to check the Format, CanGrow, and CanShrink on the Report design view as well as the user's input form.

I've had reports like this work without any problem.

John

 

[Paladyr]

Can Shrink and Can Grow are both set to yes. There is nothing there under format. When I say linked I mean that is what is in the data source. I've got no clue what could be causing this!!!

 

[Paladyr]

On your report, in which you are using a text box that prints well over 255 characters, did you create it in crystal reports??? The person who created this used access's reports. Also this is Access 2000. I don't know what else it could be. I know it isn't getting cut off in the tables, Can grow is set to yes so it should expand, the data type of the field is set to memo. What the heck??@!#!@# I even tried setting Can shrink to no and making the box rediculously large!! I'm about to give up!!!

 

[tempclerk]

Is your report based on a query? If so, can you read the whole memo there?

 

[Paladyr]

Duh, I can't believe I didn't think of that!!! That's what it is, the query is truncating that field. How do I get around this?

 

[tempclerk]

Good question. I have always avoided memo fields to avoid such problems. Hopefully someone can tell you how to get a memo field type out of a query, but if not (or while waiting for informed help), I would attempt to work-around by setting the control source of the box =DLookup("[memo]","Table","[keyfield]=[keyfield]&quot.

 

[Paladyr]

Should this work?

DLookup("General Daily Notes", "travel / trip charge log", "[Start Date] >= " &
[forms]![input form-travel weekly]![Start of Week] & &quot; AND [Start Date] <= &quot; &
[forms]![input form-travel weekly]![end of week] & &quot; AND [Specialist] = &quot; &
[forms]![input form-travel weekly]![specialist value])

 

[Databaseguy]

So, your question now is:

How do I get a query to display more than 255 characters?

Correct ? Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[Paladyr]

Yep, since I can't get the DLookup to work