HELP: FORMATTING TEXT BOXES IN FORMS

[HenryE]

Hi All,

Anyone know if it is possible to format text boxes and labels in Access forms so that, for example, the text is pushed in one space? Basically, I'm trying to have it not pressed right up against the side of the text box or label, and was wondering if this can be done automatically. I'm trying with various uses of the @, but it's not working so far.

Thanks much.

Henry

 

[dakota81]

I'm thinking you could add a space in from the Before Update property of the text box.

This example would keep a space on the left side of the text inside the box at all times:


Public Sub TextBox_Before_Update

If Not Left(TextBox.Value, 1) = " " Then
TextBox.Value = " " & TextBox.Value
End If

End Sub

 

[dakota81]

Oh, that would work for Text only, wouldn't work for fields set as numbers or dates.