A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Null values in word 2003 calculations



 
 
Thread Tools Display Modes
  #1  
Old September 10th, 2009, 07:33 PM posted to microsoft.public.word.tables
Lenny
external usenet poster
 
Posts: 112
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
field.

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
appreciated.

Lenny
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.