Blanks in text boxes

[Guest]

I have a text box which sums the scores from 12 selection criteria. the user
needs to rank each criteria between 1-10. Another text box provides advice
whether to proceed with a particular project based on that final score. ie.
Score>0 and <=20 - proceed; Score >21 and <=40 "proceed with caution" etc.
This all works fine. When no-one has filled out the form for a particular
project, the Score textbox reads "0" with the corresponding text in the other
text box. What I wish to do is have each text box blank when the form has yet
to be filled in.
many thanks
SJW123

 

[Al Camp]

SJW123,
Hmmm... this project sounds familiar. I believe we hashed out the
"scoring" text some time ago... Glad that everything is OK with that.
You can leave the 0's in your text boxes, but just hide them through the
Format Property of each text control.
I'm assuming all fields are defned as numeric, either Byte, or Integer,
or Long.
This format...
#;-#;""
will display 1 as 1, -1 as -1, and 0 as blank. See Formatting Numbers in
Help.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

You can place that format in all your Response fields, as well as your
Total, for all "blank" fields on a new record.

 

[Guest]

Yes, correct Al we did hash this out a week or so ago. Just thought it looked
a bit stupid seeing 0 and "Worth Pursuing" on my form and report with these
text boxes when the form hadn't yet been filled in.
Thanks for your help and have managed to get blanks in both text boxes to
appear.
SJW123