Text box default value

[Peggy]

I have already created a form based on a table. Now I have
decided I want a default value in some of the text boxes.
I thought I could just go to the properties for the text
box and, for example, type "Denver" as the default value
for city. However, this default value doesn't appear on
the form.

 

[Allen Browne]

The Default Value property does not apply to existing records where the
field is blank.

It is the value that is automatically assigned to the field when a new
record is added.

To put a value into the existing records, use an Update query: Update on
Query menu in query design view.

 

[John Vinson]

I have already created a form based on a table. Now I have
decided I want a default value in some of the text boxes.
I thought I could just go to the properties for the text
box and, for example, type "Denver" as the default value
for city. However, this default value doesn't appear on
the form.

It should when you start entering data in *some other* control.

 

[Peggy]

It still doesn't work. I deleted all the records so I have
only clean forms with no one entered. I go the design view
of the form. Select the properties of the text box.
Enter "Denver" as the default value for the city. Go back
to form view and nothing. Do I have to recreate the entire
form? Go back to the table and set "Denver" as the default
there? Redo the relationships?

 

[Guest]

OOPs. Now it'e working

-----Original Message-----
It still doesn't work. I deleted all the records so I have
only clean forms with no one entered. I go the design view
of the form. Select the properties of the text box.
Enter "Denver" as the default value for the city. Go back
to form view and nothing. Do I have to recreate the entire
form? Go back to the table and set "Denver" as the default
there? Redo the relationships?





.

 

[John Vinson]

It still doesn't work. I deleted all the records so I have
only clean forms with no one entered. I go the design view
of the form. Select the properties of the text box.
Enter "Denver" as the default value for the city. Go back
to form view and nothing. Do I have to recreate the entire
form? Go back to the table and set "Denver" as the default
there? Redo the relationships?

What happens when you enter a value into *SOME OTHER* control on the
Form? Only then is there a new record being created.