×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

Retro Filling Blank Cells
2

Retro Filling Blank Cells

Retro Filling Blank Cells

(OP)
Is there a way of retrospectively filling any empty cells that may remain in a single (text) field of an Access 2000 table - say an X or even a few words? Many thanks in advance to anyone who can help.

RE: Retro Filling Blank Cells

(OP)
Apologies for my confusing terminology. I meant "single (text) column".

RE: Retro Filling Blank Cells

Hi!

Try writing an update query.  In the QBE select your table and then select the field you want to update.  Click on the query type button, next to the run button, and select update query.  Set the update to to IIf(Nz(Len([Table]![Field]),0)=0,"Your filler here",[Table]![Field]).  This will keep whatever is there and add your filler if the field is blank.

hth
Jeff Bridgham

RE: Retro Filling Blank Cells

A better way would be to make the update query, put the thing you want to appear in the field in quotes (ie: "BLANK") and then place criteria on the field below like this:

Is Null OR ""

HTH

Joe Miller
joe.miller@flotech.net

RE: Retro Filling Blank Cells

I vote for joe's solution... simply and less prone to typo's.

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