How to Repeat Text in Multiple Record Fields?

  • Thread starter Thread starter Larry Bohen
  • Start date Start date
L

Larry Bohen

I want to repeat the same text in the same field in multiple Access 2003 SP2
records.

How do I do this?
 
You could try opening your table in design mode and then highlight the field
you want the repeated text in. At the botton in the property box for the
field there is a "Default Value" property. Put the text you want in there.
 
In that I want to insert text in muliple record fields for a subset of a
11,100 record database, I can't use such a global method unless I am
misunderstanding your idea.

Thanks anyway.
 
Then build a query that returns the subset of records that you want, turn it
into an update query entering the text you want in the field you want
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple selection in text field? 1
Data Entry to Form with repeat data. 13
last recordset 4
Access Dcount (multiple criteria) 3
how to merge mult records into a single record 2
Printing multiple forms with linked images...How can I make the images work? 0
Access Access - Is it possible to repeat fields in a form? 1
allowing multiple values causes front end to report error 5

Back
Top