Reducing white space (padding) of Text Box field control

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:

Related Topics

Quickly Set Form Control Padding
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
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.


Complicated white space question
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. My question:

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


Access 2007 - Adding Padding to Report control
In Access 2007 does anyone know how to use the Padding properties through code?

I have two textboxes and I have them "Stacked" on a report, I can add padding through the properties box, but not through code, why is that?

Me!Textbox1.BottomPadding = 2

Also, can you reference the "stack" through


Flash Textbox Backcolor White and Red
I have searched for code to flash the backcolor of a text box but haven't found what I want. I am sure it is a simple timer but I know just enough to be dangerous.

If a user changes a date in a text box (SubmitDate) on form 1 and tabs out of the field, I have code in the AfterUpdate event to update this date change on a text box on form 2 (that is also open) so they stay in sync.

I have some code that changes the backcolor of the text box on form 2 to red, then changes it to white, then red again and then back to white so it appears to flash, but it is very inefficient.

Is there a simple way to alternate the backcolor from white to red, to white, to red, then back to white with a 1/2 second interval between each colorchange? I am using DoEvents so I can continue other processes while it changes color.


Flash Textbox Backcolor White and Red
I have searched for code to flash the backcolor of a text box but haven't found what I want. I am sure it is a simple timer but I know just enough to be dangerous.

If a user changes a date in a text box (SubmitDate) on form 1 and tabs out of the field, I have code in the AfterUpdate event to update this date change on a text box on form 2 (that is also open) so they stay in sync. I have some code that changes the backcolor of the text box on form 2 to red, then changes it to white, then red again and then back to white so it appears to flash, but it is very inefficient. Is there a simple way to alternate the backcolor from white to red, to white, to red, then back to white with a 1/2 second interval between each color change? I am using DoEvents so I can continue other processes while it changes color


White Space at end of Report before Page Number?
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.


White Space in a Report after Hide Duplicates
My report is totalling after each procedure type and I have told the properties to 'hide duplicates', but the white space is still showing on the printed report, before the total. How do I remove the white space and keep the totals?

I meant to include that I am using Access


Excess white-space in Report
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.


Unbound Text Box Formatting
I have created an unbound text box on a form. I have set the format properties to transparent for the back style and the border style. Everything looks correct in Design View and Layout View, but when I switch to Form View, the box shows a white background and all the text in the box is highlighted in black. I can click off off the box and unhighlight the text, but there's still a white box. I'm sure I'm doing something wrong


Remove White Space
I have used the following to hide record fields that are blank as well as their label.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.Calculation_Label.Visible = Not (IsNull(Me.Calculation))
Me.Definition_Label.Visible = Not (IsNull(Me.Definition))
Me.Interpretation_Label.Visible = Not (IsNull(Me.Interpretation))
Me.StandardsBenchmark_Label.Visible = Not (IsNull(Me.StandardsBenchmark))
Me.DataSources_Label.Visible = Not (IsNull(Me.DataSources))
Me.SecondarySources_Label.Visible = Not (IsNull(Me.SecondarySources))
Me.Comments_Label.Visible = Not (IsNull(Me.
End Sub

My report now has lines of white space where that data would have been had it not been blank. Is there a way to remove the white space?


Why is text box not updating?
I have a form named frmPaymentDetails with following control:

[DefaultFees] - Text box. Control source is taken from a field in a Table.
[AmountPaid] - Unbound text box control.

Problem: I update the value in DefaultFees by manually typing a new value in the text box. And then I hit a button which calls a subroutine.

Private Sub DefaultFeeUpdateButton_Click()
' Refresh the [Amount Paid] text box
Me.AmountPaid.Value = Me.DefaultFees.Value
Me.AmountPaid.Requery
End Sub

However, inside the subroutine, Me.DefaultFees.Value shows the old value, which I've already overwritten in the text box manually. It is not reading in the new value which I typed...


Tab Control - Pages
I have a common text box control which appears on all 4 pages of my tab control. (Common text box control achieved through pasting a text box control onto the tab)

I only want the user to be able to change the data in this text box control if they are on Page 1. If they are on any other Page, then I would like to Lock the text box control.

If there was a Got Focus event for a Page then I could do what I need; but there isn't!

Is there a way to determine which Page of my Tab Control is active


Nutty error
I've got a db in Access97 running on XP. It's 90Mb in size, with 100K records. Most of the data is in one table, with a few ancilliary lookup tables.

When I try and change the field size on any text fields, I get an odd error message on saving. It doesn't matter whether I'm increasing or decreasing the size.

"Microsoft Access can't change the data type.

There isn't enough Disk Space or Memory"

Disk space isn't a problem, there's 15gb free on a 27Gb network partition. And my PC is fine, it's a dual core with 2Gb.

If I reduce the size of the text field I get the message that data may be truncated as you would expect, and then the message. There's no way that reducing the size of a field should give that message.

The field isn't linked via a relationship to anything, it's a free text comment field.

I've tried backing up the Db and compacting, as that usually sorts weird errors out, but not this time


Command button
How come on one of my command buttons it places a white border box around the control? I have the 'back style' to transparent, but this white box still shows up on my command button. However, none of my other commands have this white border box. All of the properties look to be thee same..didn't see anything different on 1st glance.


Form Text Box Control Events
Using Access 2010 accdb, I have a form with an unbound Text Box Control. The Control Source is defined by the Form On Open Event. One option is for a string (function) to populate the Text Box Control and the other is for a Value to be placed in the control.

Both options result in automatic population of the control with a Currency value. I would like a Command Button control to be Enabled - True or False depending on the value. as per the code below.
Code...


Count row before text in a control
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]


Add a text box control to a form or report
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.


One Report field in two side-by-side columns?
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?


Text control to act like combo control
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