auto text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tyler - 11 May 2007 21:22 GMT

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?

Reply to this Message

Damon Heron - 11 May 2007 22:00 GMT

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

> 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?

Reply to this Message