The With...End With statement executes a series of statements on a single object or user-defined type : Form Control « Forms « VBA / Excel / Access / Word
The With...End With statement executes a series of statements on a single object or user-defined type
Private Sub cmdWithEndWith_Click()
With Me.txtAge ' Your Text Field's name
.BackColor = 16777088
.ForeColor = 16711680
.Value = "Hello World"
.FontName = "Arial" End With End Sub