473,320 Members | 1,831 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

A2K - a quick one about textbox grow property

Is there a limit to how much the textbox will expand? I just noticed in a
report that the textbox isn't expanding enough to show all of the text
entered in a textbox. Bit odd if this is the case - can this be overcome?
Jul 11 '08 #1
6 2138
Deano wrote:
Is there a limit to how much the textbox will expand? I just noticed
in a report that the textbox isn't expanding enough to show all of
the text entered in a textbox. Bit odd if this is the case - can
this be overcome?
More likely is that your text is being truncated either by your query or
your report. If it's a memo field you cannot set the format property or
group on it (or a few other things) as that will cause the text to be
truncated at 255 characters.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jul 11 '08 #2
On Fri, 11 Jul 2008 20:15:34 +0100, Deano wrote:
Is there a limit to how much the textbox will expand? I just noticed in a
report that the textbox isn't expanding enough to show all of the text
entered in a textbox. Bit odd if this is the case - can this be overcome?
Are you sure the query that is the report's record source is returning
the full text and not truncating it at 255 characters.

You do have the control's CanGrow property set to Yes, don't you?
In a report, as far as I know, there is no limit to how much a text
control will grow. Make sure the section the control is in is also set
to CanGrow. If the section doesn't grow along with the control, there
is no place to display the additional text.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Jul 11 '08 #3
Deano wrote:
>Is there a limit to how much the textbox will expand? I just noticed in a
report that the textbox isn't expanding enough to show all of the text
entered in a textbox. Bit odd if this is the case - can this be overcome?
A text box should grow to accomodate the maximum number of
characters (64K) that a text box can hold. If it's not
doing that, check to make sure that the section containing
the text box also has its CanGrow property set to Yes.

The only other reason I have ever heard of is a bad font.

--
Marsh
Jul 11 '08 #4

"Rick Brandt" <ri*********@hotmail.comwrote in message
news:4A*****************@nlpi069.nbdc.sbc.com...
Deano wrote:
Is there a limit to how much the textbox will expand? I just noticed
in a report that the textbox isn't expanding enough to show all of
the text entered in a textbox. Bit odd if this is the case - can
this be overcome?

More likely is that your text is being truncated either by your query or
your report. If it's a memo field you cannot set the format property or
group on it (or a few other things) as that will cause the text to be
truncated at 255 characters.
Thanks Rick, this grouping is the problem. I have an append query that
groups on this memo field - the resulting table is the recordsource. I
guess I can't prevent this truncation from happening then?
Jul 12 '08 #5
>I guess I can't prevent this truncation from happening then?

You're correct, Deano! The Grouping of the Memo field is causing the
truncation! Allen Browne explains all of this in the article here:

http://allenbrowne.com/ser-63.html

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200807/1

Jul 12 '08 #6
Linq Adams via AccessMonster.com" <u28780@uwewrote in message
news:870aefcd6f98b@uwe...
I guess I can't prevent this truncation from happening then?

You're correct, Deano! The Grouping of the Memo field is causing the
truncation! Allen Browne explains all of this in the article here:

http://allenbrowne.com/ser-63.html
Thanks. Looks like the solution is just to change to First!
Jul 12 '08 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: ken | last post by:
Hi How do I use the bindings for a textbox via the properties window? If I click the the bindings dropdown, there are two properties that can be bound, tag and text. Is this used only when I...
11
by: Keith | last post by:
I apologize for those of you who think I'm posting on the same topic. It is not that I don't appreciate all of your comments - and I'm definitely reading them all - but I think I have a differing...
1
by: welles.lo | last post by:
Hi all, I found that the default "can grow" in Crystal Reports 10 is different from the one in Crystal Report 9. In version 9, when "can grow" is disable, the words in the field are chopped...
4
by: MLH | last post by:
I have a report and on it, a subreport control Main Report Name: rptInvoiceMain Sub Report Name: rptInvoiceSubReport SubReport Control Name: rptInvoiceSubReportCtl The...
1
by: subhodey | last post by:
Hi, I am running a report in MS Access 2003, and it has some fields placed side by side. One of the fields is a textbox named "Title". In the property option of this textbox, the "Can grow" is set...
8
by: Lynx101 | last post by:
Hi, hope anyone can help with this query. Background: Subform datasheet link to a form to store updates on projects. Query: I have a datasheet where one of the field is a memo field. When...
2
by: mikeys7772 | last post by:
I have a report textbox that contains a name. Because the report is for labels, I don't want it to grow. Instead, I want to see if the name is too big for the field width and then reduce the size...
10
by: karan1981 | last post by:
Hi, I have a user control that has a textbox. This user control is placed in a form at runtime. This form gives a string to the user control and the textbox is to show this in multiple lines.(i...
1
by: franc sutherland | last post by:
Hi, I am using Access 2003. I have set up an invoice in a report. I have set up the name and address as text boxes in the Page Header which I've made as small as possible then set the Can...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.