Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Lenny Lenny is offline
external usenet poster
Posts: 74
Default Null values in word 2003 calculations

I have Word 2003 protected form template consisting of a table with 5 rows
and 5 columns. Each of the 25 cells represented in the table has 2 fields...
a dropdown field and a bookmarked field to hold the value of a module
containing SelectCase. At the bottom of the form are cells for each of the 5
columns that Total the 5 values above.

The form is blank until the user makes a selection from the a dropdown (1,
2, 3, 4, 5) in any of the cells. Once selected, depending on the number
selected, the user then moves out of the cell (tab or clicks on anyther
dropdown) an On Exit macro fires the code to add the value to the bookmarked

I want the user to be able to 'clear' the form... reset the dropdowns, the
fields with the SelectCase results, and the totals. Currently... The first
item in the dropdown is actually a 'space'. This is so the field appears
'blank' until one of the values in the dropdown is selected, thus, setting
off the chain of events.

The form works, correctly displaying the contents of the dropdown and the
corresponding value. It is adding the values correctly in the Total cell at
the bottom.

The problem..... when the dropdowns are cleared, which actually means just
selecting the top item in the dropdown, the 'space', the value fields will
not clear, regardless of whether I tab out of the field or do a print
preview. If I unprotect the form, do a 'select all' and press ALT F9 they
still do not clear.

Is there a way to assign the 'space' in the dropdown a null value in the
SelectCase so nothing is added to the bookmarked field, thus resulting in
null values in the other calculations. I don't want any values to show on
the form, in case the user needs to copy the form to fill in by hand.

I'm close.... but still so far

Can someone point me in the right direction? Help is always greatly

Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2003 table calculations Lenny Microsoft Word Help 1 June 4th 08 11:55 AM
SUM of two mergefields with possible null values bronco104 Mailmerge 4 March 10th 08 08:46 PM
Calculations in Word 2003 Table Stampie Microsoft Word Help 9 March 17th 07 06:35 AM
Is there a way of adding null alternative text in Word 2003? ATPO Microsoft Word Help 0 March 31st 06 10:11 AM
Calculations in Word 2003 Yappy Box Microsoft Word Help 3 January 13th 06 04:40 PM

All times are GMT +1. The time now is 04:19 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Word"