Reducing white space (padding) of Text Box field control
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?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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.
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
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
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.
[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
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...
I meant to include that I am using Access
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