Text character limits

[Moni]

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?

 

[Tom Wickerath]

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
__________________________________________

 

[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

 

[Tom Wickerath]

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