Autofill or fill down

[Marilyn]

I have a database with approx. 2500 records. I need to change the contents
of one of the fields to include a constant text value. I have found a way to
insert a constant text value for new records added to the dbase but I can't
seem to find a way to change all of the text values in a column for previous
records at one time. I have thought about find and replace but that could
take some time as well. In Excel, one could do a fill down. Is there such an
option in Access? Any ideas of how I can fill a particular field with the
same information in an existing dbase?

 

[Jeff Boyce]

Marilyn

Are you saying that EVERY record in your table will have the same value in
the particular field? If so, why bother! You could, instead, use a form
and "hard code" that value into a textbox on the form. Any time a record is
loaded into the form for review or edit, the hard-coded value would be
there.

If you MUST store a constant in a field, take a look at an Update Query.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Marilyn]

Thanks Jeff. I am actually helping someone else and from I gathered, that is
what they wanted. Your solutions are good solutions. I just hadn't thought
of that aspect as we something get stuck in a groove based on what they want.
I'll share both options with them to see what will work for them.

I appreciate the quick response and help as she will also as she kind of
wanted the answer yesterday at about 5 pm.

Marilyn