filling columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The columns in my table have varied values but often I get a whole lot of new data to enter where the values are the same for many records. ie Date joined with the same date for multiple records. In spreadsheets it is possible to click on one cell, highlight the column and type or click on "fill" and the column is filled in with the proper data. I am right that this is not possible in Access?
 
I am right that this is not possible in Access?
Click to expand...

Quite right.

What you can do if (as you should!) you're using a Form to enter the
data is to set the default-value property of a textbox in the Form's
AfterUpdate event:

Private Sub Form_AfterUpdate()
Me!txtThis.DefaultValue = Chr(34) & Me!txtThis & Chr(34)
End Sub

Chr(34) is ", required as a delimiter for the default-value text
string.
 
Back
Top