Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Default Value not Saved

Default Value not Saved

Default Value not Saved

I am using Microsoft Access 97 with an existing database having multiple tables. I opened up one of the tables, went to View-Design View, clicked on a particular Field, changed the Type from Yes/No to Text, entered comments in the Description Field and set the Default Value to a text value. Then I saved the changes. I also manually edited that field in the Datasheet View by filling in text values for entries in that field.  I closed the table and reopened it. The Type remained Text and the values in that field for all of the entries in the Datasheet View remained. But the Default Value and the Description comments disappeared.  Does anyone know why this happened and how I can get this Default Value to stick? I'd like to be able to automatically fill in new entries with this Default Value but whenever I try to close the table (or the database) the Default Value that I typed in and saved, disappears.

RE: Default Value not Saved

Sounds odd. I tried this and had no problems. If you put in a default value in table design view, that value should appear in the new record line (the one with an asterisk at the left) at the bottom of the datasheet, in the column for that field.

Alex Middleton

RE: Default Value not Saved

Did you try Compacting and Repairing the database?  Lots of weird things can happen that this fixes.

Joe Miller

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close