By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,453 Members | 3,183 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,453 IT Pros & Developers. It's quick & easy.

How to find the number of characters allowed in a vba report's textbox?

Malathi
P: 31
Hi friends,

Im a newbie to vba access. Im having a editable combobox in a form that allows atmost 50 characters to be typed in.(I just run the form and typed how many characters it allows..I couldnt find the fieldsize for this also :( ) But when the report is pulling the data, it displays only a little bit.
Ex: abcde (In form's combo), abc (In report's textbox)
Its just an example, not the exact scenario. Here the problem is Im unable to find the number of characters allowed by the report to display. I tried to run the report. But as the form data has to be processed by some other applns, the report has currently no data. Now my task is to change the form's combobox fieldsize to the report's textbox fieldsize(no. of characters allowed). So can you pls help me to identify the number of characters allowed in report's textbox? Thanks in advance!

Malathi
Mar 31 '12 #1

✓ answered by Stewart Ross

If you set the Can Grow property of the textbox on the report to Yes it will automatically increase in size vertically to show all of the text concerned on multiple lines.

Controls do not have in-built limits on the number of characters they can display.

If you do not want the control to grow vertically on the report you will just have to size the control horizontally for the best fit as Mihail has advised. Counting the number of characters you can fit in is not going to help much. When using proportionally-spaced fonts such as Arial some characters take up much more space than others (compare 'W' and 'I', for instance).

-Stewart

Share this Question
Share on Google+
3 Replies


100+
P: 759
Try to enlarge the control in report.
Open the report in design view, select the control (the text box) then drag from an edge or corner to enlarge it as more as you need.
Apr 1 '12 #2

Expert Mod 2.5K+
P: 2,545
If you set the Can Grow property of the textbox on the report to Yes it will automatically increase in size vertically to show all of the text concerned on multiple lines.

Controls do not have in-built limits on the number of characters they can display.

If you do not want the control to grow vertically on the report you will just have to size the control horizontally for the best fit as Mihail has advised. Counting the number of characters you can fit in is not going to help much. When using proportionally-spaced fonts such as Arial some characters take up much more space than others (compare 'W' and 'I', for instance).

-Stewart
Apr 1 '12 #3

Malathi
P: 31
Problem solved! Thanks for Stewart and Mihail.
Apr 5 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.