Help with multiple condition unbound text box

R

RNUSZ@OKDPS

I need to convert Fox Pro 2.6 text box on form letter to fit stored data in
MsAccess and unbound text box. Old code follows:

It is further ordered, pursuant to 47 o.s. 7-206, that the license and
registration(s) of (licensee) shall remain suspended unless (if security> " "
) said security in the amount (security) is posted and (eif) proof of
current insurance in your name is filed with this Department along with a
$100.00 reinstatement fee in the form of a cashier's check or money order
made payable to the Department of Public Safetly.(els) are hereby suspended
unless (if security > " " ) said security in the amount of (security) is
posted and (eif) proof of current insurance in your name is filed with this
Department before (revocationdate).

There are 4 different text statements available from this paragraph, I need
to be able to code the same output via MsAccess in an unbound text box. Any
suggestions.
 
K

Klatuu

I don't know how you get the data into the text box, with that info I could
give more info, but basically, to put the text together is not that difficlut.

Most likely, You should code this as a function, then put the function in
the Default Value property of your text box.

Me.txtThreat = "Blah Blah Some Text " & XXXXX & " Blah Blah We are sending
Blacky to break your knees " & XXXXX & " Send us all your money or we will
come rip " & XXXXX & " Dollars out of your pocket. Have a nice day Mr. " &
XXXXX & "!"

Where XXXX can be:
a variable
a field from your table
a calcuation
the results of a function call
the value in a control on your form
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top