Entering default values for already created records

[sunshine3]

Hello,

I have a student database, in which i have already entered all records.I created a semester field later.Now, i want this field to carry a default value of "spring".What i did is that in the options section for fields i entered the default value in auto-enter tab.But, this works only if i create a new record(that is , it enters the default value for all new records) and not the already created ones.Is there a way that for these already existing records also the default value gets entered.I am asking because no.of already existing records is 700!! and i dont want to enter manually.

Any help will be appreciated

Thanks,

sunshine3

Edited June 7, 2010 by Guest

[LaRetta]

Hi Sunshine3,

You need to place the value in those records yourself. Back up first then find all records with no value by searching for = in the field. Place your cursor in the field and type Spring. The select Records > Replace Field Contents and first radio button will say, "Replace with Spring." Below, click the Replace button. :wink2: