auto text

  • Thread starter Thread starter Tyler
  • Start date Start date
T

Tyler

I've created a database that will contain information about
properties. One of the fields requires the entry of a road name. I
was wondering if there was a way to code the field so that it would
A) recognize previous entries for roads so that as the person typed
it would auto fill and B) be all capitals?
 
Just use a combo box instead of a textbox and set the control source to the
street field and the rowsource to the street name (click the "..." next to
row source and build a simple query to show only the street names in the
combobox. As the user types it will go to any previous names.

For uppercase, in the afterupdate event of the combo-

Private Sub Combo1_AfterUpdate()
Me.Combo1 = UCase(Combo1)
End Sub

HTH
Damon
 
Back
Top