PDA

View Full Version : Solved: label caption



av8tordude
07-15-2010, 10:55 AM
Night2.Caption is formated to display numbers in parenthesis (i.e. 1.0). I using the code below to insert this number into a textbox on page0 of a multipage. The code below works as expected, inserting (1.0) in txtNight textbox.


txtNIGHT.Value = Night2.Caption, "0.0"

When the number is inserted into the textbox as (1.0), I tried using the code below to take the parenthesis away, but now it displays -1.0.


txtNIGHT.Value = Format(Night2.Caption, "0.0")

how can I make it display as 1.0 in the textbox, but keep the Night2.Caption format the same?

Thanks

Bob Phillips
07-15-2010, 11:27 AM
Maybe



txtNIGHT.Value = Format(Night2.Caption, "0.0;0.0")

av8tordude
07-15-2010, 12:55 PM
Thank you XLD :friends: