fill in all blank cells of table

[Guest]

Hello,
How would I place a " " in all blank cells of a table?

I've found that if I export the table as text into Dreamweaver I can do,
among other
things, create alternating colored rows. If the blank cells contain a
"&nbps;" the table will render correctly on the web.

Thanks for your help,
Ellen

 

[Guest]

Access will not store trailing spaces.

 

[Guest]

I Karl,
Thanks for responding to my question. After I pressed the "post" button, I
remembered that I need an update query to add spaces to empty cells.

Bye,
Ellen

 

[Guest]

An update query would be you best option.

Choose the field with the criteria Is Null and the Update To would be " "
that might work.