Text character limits

[Guest]

I've increased the character limits for my text field in my table design to
255 characters. However, in my report, it's still only showing 50
characters. Any suggestion?

 

[Guest]

Is the size of the textbox large enough to display more than 50 characters?
To be sure, open the report in design view. Click on View > Properties to
display the properties dialog (if it is not already displayed). Select the
textbox in question. You should see the name of the textbox displayed in the
title bar of the properties dialog. Select the Format tab. Set the Can Grow
property to Yes.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Joseph Meehan]

I've increased the character limits for my text field in my table
design to 255 characters. However, in my report, it's still only
showing 50 characters. Any suggestion?

You need to make the control in the report larger or allow it to "grow."

 

[JK]

Is there any way to convert a 'memo' field into a text field?

I want to take the last 200 chars out of a memo field and dump them
into a text field. Is that possible?

Thanks much.

jk

 

[Joseph Meehan]

Is there any way to convert a 'memo' field into a text field?

I want to take the last 200 chars out of a memo field and dump them
into a text field. Is that possible?

Thanks much.

jk

I have not tried it, but the right function should do it. Just use an
update query.

 

[Guest]

Hi Joseph,

I think the Right function will work okay for this, if JK is using Access
2000 or later (ie. JET 4.0). When using Access 97 (JET 3.5), I know that the
Left function will not work past the 255th character. I suspect, although I
have not tested, that the Right function would have the same limitation in
Access 97.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[JK]

Thanks Tom and Joesph.
I could have sworn it didn't work yesterday, but today,
"=right([note],200)" works just fine. Yesterday it was giving me
Error0 as the result.

But now it's fine.

(sigh)

jk