Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / August 2006

Tip: Looking for answers? Try searching our database.

How can I set up Word to calculate a value and show it in a form?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andrew_Wilson - 28 Aug 2006 13:05 GMT
Hello, I am working on a nursing shift turn over form. One of the things I
would like to do is set it up to calculate length of a baby.  We enter in the
CM  and in another block it automatically calculates the inches.

I have the CM box set as a number, and has a bookmark of Text36.  Then my
next box is for inches.  It is bookmarked Text37.  I have it set as a
calculation. In the expression box I have  = Text36 / 2.54.  When I save out
of the Field Options box it does the calculation and puts the correct value
in there.  When I protect the form and use it, no matter what I put in Text36
(the CM box) it doesnt change Text37 (the inches box.)  Is there a way to do
this? Does someone know an example maybe that I could look at to get it to
work?  Thank you so much for your time.

Andrew
Greg Maxey - 28 Aug 2006 13:16 GMT
Andrew,

For Text35 do you have "calculate on exit" checked in the Field
Options?

> Hello, I am working on a nursing shift turn over form. One of the things I
> would like to do is set it up to calculate length of a baby.  We enter in the
[quoted text clipped - 10 lines]
>
> Andrew
Andrew_Wilson - 28 Aug 2006 14:30 GMT
Do I have to put calculate on exit on Text35? It doesnt have anything to do
with the calculation I am trying to do.  Thanks for your response.

Andrew

> Andrew,
>
[quoted text clipped - 15 lines]
> >
> > Andrew
Greg Maxey - 28 Aug 2006 14:40 GMT
Well no, that was a typo.  I meant do you have calculate on exit set in
Text36?
> Do I have to put calculate on exit on Text35? It doesnt have anything to do
> with the calculation I am trying to do.  Thanks for your response.
[quoted text clipped - 20 lines]
> > >
> > > Andrew
Andrew_Wilson - 28 Aug 2006 14:55 GMT
Thanks Greg! That did it.  I very much appreciate your time.  I thought that
that check box was for the actual box you wanted the calculations done in.
Thanks again for your time.

Andrew

> Well no, that was a typo.  I meant do you have calculate on exit set in
> Text36?
[quoted text clipped - 22 lines]
> > > >
> > > > Andrew
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.