Topics Search

Reducing white space (padding) of Text Box field control

Reducing white space (padding) of Text Box field control
Views: 106
Access 2007 is not obeying my request to reduce right-side padding for a right text aligned control. I have gone as far as setting this one field control's Right Margin / Right Padding properties both to 0, the text align is set to right.

Yet Access insists on leaving some white space at the right side of the field control, and the data is large enough it is spilling offthe left edge of the field control.

So, in Access, what should the Right Margin / Right Padding properties control?

Is there another property I have not thought to adjust to be able to reduce field white space?
Sponsored Links:

Similar posts...

 

Quickly Set Form Control Padding

Quickly Set Form Control Padding Icon
Setting Forms in required shape is no less than a laborious work, as you have to adjust each element at the position you want. Access 2010 offers 3 types of padding control to set the padding in Narrow, Medium, and Wide layout.
 

Complicated white space question

Complicated white space question Icon
I have an excel spreadsheet with varying fields (Name, Address, Phone Number, etc.) Each of these fields obviously varies in total characters in the field.

Regardless of the number of total characters in the field, once imported I need access to add WHITE SPACE (Additional Spacing or Empty Character Space) to reflect that the field has whatever amount of Characters I specify.

So for example, my NAME field needs to have a total of 20 Character Size but names such as Brown and Smith have only 5.I need to add 17 SPACES or WHITE SPACE behind that.
 

White Space at end of Report before Page Number?

White Space at end of Report before Page Number? Icon
I have two reports that were created one from the other (same information for the most part with a few changes to the copied one). On one of them, when I view the Report (Not Print Preview), there is a HUGE amount of white space between the last record and the Page Number.

On the copied report, there is no white space between the last record and the page number.

It doesn't affect the printing of the report, but when a user is looking at the report in Access, they can see the white space andI have been asked why it is doing that (really annoying).

I have compared all the Detail, Header and Footer properties and could not identify any differences that may contribute to this.
 

Add a text box control to a form or report

Add a text box control to a form or report Icon
The text box is the standard control used for viewing and editing data on forms and reports. Many different types of data can be displayed in text boxes, and you can also use them to perform calculations. This article explains how to create and use a text box and also explains some important text box properties.
What do you want to do: Add a bound text box, Add an unbound text box, Add a calculated text box, Understand text box properties.
 

Excess white-space in Report

Excess white-space in Report Icon
A legacy Database, using Access 2000, is generating too much white space, effectively adding an extra page to the report. I'd appreciate any assistance in trimming the excess space.
 

Count row before text in a control

Count row before text in a control Icon
I have a report with a text box and I want to be able to start with on and count for every text box for each record like:

1) Some text
2) Some text
3) Some text.

Right now I have a text box that has =1 as its control source but I need it with the text it self not in its own text box.

In the text box I want to add a number its control source is =" " & [BasicJobSteps]
 

Text control to act like combo control

Text control to act like combo control Icon
I need a text control filed to display the text in a combo box, not the lookup field the combo box is based on.

The combo box stores values for fieldA in it, but displays fieldB. I need a text box to display fieldB based on the combo box selection.
 

One Report field in two side-by-side columns?

One Report field in two side-by-side columns? Icon
On a report that I have designed to print out labels - I have enough vertical space to display only 4 rows of data for this one 20-character field.

However, I have enough horizontal real-estate on the report to allow for a second identical text box beside the one that can display the first 4 rows of data.

How do I make the 5th - 8th rows of data appear in the second text box? I don't remember ever having to do this before.

I have a feeling that there may be a control other than a Text Box that will allow for this scenario. But I haven't been able to figure it out yet.

I'm wondering if I will have to tweak the Sql to return the top 4 rows for the left 'column' and rows 5 - 8 for the second one?
 

Stop selecting all the text in a text box?

Stop selecting all the text in a text box? Icon
I am now updating this mdb database using Access 2010 (but it's still in mdb format). The problem is that since I moved a particular text box from the main part of a form to the 2nd page of a tab Control, when I enter this text box, all text is selected.

The Client Setting for behavior on entering field is go to start of field. That should eliminate my problem, but it doesn't.

The data source the problem control is a Memo field. When this text box was on the main form, a macro for the Enter event set the selection start to 0 and the length to 0. (Actually I shouldn't need this, but I did.) I moved the Notes field to Page 1 of the Tab Control. It's the only field on that page.

Typically I want to edit fields on the 1st page of the tab control. I move through fields on the 1st page using the tab key. When I use the tab key to leave the last field on Page 0, I get to the Notes memo field on the Page 1, but ALL the text is selected ! and the Enter event macro does fire.
 

Variable width text box in a report

Variable width text box in a report Icon
I am trying to create a report with several text boxes on a line. The data from each field is variable in length and I need the spacing between the last character in one text box to be only one space from the first in the next text box. Is there a way to have the text box be variable in width? I.e. I now have: