RESOLVED ** Format - does not work

Hi

Why will this statement not format the users input....

VB Code:

txtinformation = Format$(txtinformation.Text, "####.00")

Thanks

For ex:
a user inputs a value i.e 12345 but I need the format function
to take this number and format it accordingly so txtinformation
would read i.e 1234.5...

Thanks

;)

If you read up on the Format function, you'll see that's not exactly how it works, but try this...

VB Code:

Format$("12345", "@@@@.")

Or this...

VB Code:

txtInformation.Text = Left$(txtInformation.Text, Len(txtInformation.Text) - 2) & "." & Mid$(txtInformation.Text, Len(txtInformation.Text) - 1)

Thanks

Both examples work a treat......

Thanks
;) ;) ;)

Or use the masked edit box (with a mask of ####.# ) instead of the normal text box.

Holly, you're fond of the 'ol winking aren't ya ;)

Quote:

---

Originally posted by plenderj
Holly, you're fond of the 'ol winking aren't ya ;)

---

Yes!! ;) ;) ;) ;) I liked to be winked at!! ;) :blush:

Quote:

---

Originally posted by holly
Yes!! ;) ;) ;) ;) I liked to be winked at!! ;) :blush:

---

Oh do you indeed ;)

:blush: :blush: :blush: :blush: YES!! ;) ;) :blush:

So how's sunny manchester à la mer this time of year then ?

Its Not too bad - When does the sun ever shine on Manchester?
rain now thats a different matter!! ;) ;) How's sunny Ireland? or
is Ireland as bad as Manchester?

;) ;)

Ireland, the most beautiful country that ever was, being compared to Manchester?
Not to say anything against Manchester, but I'm offended ;)

Quote:

---

Originally posted by plenderj
Ireland, the most beautiful country that ever was, being compared to Manchester?
Not to say anything against Manchester, but I'm offended ;)

---

Whats wrong with comparing Ireland to Manchester? ;) Whats
wrong with Manchester????? ;)

I was not comparing manchester to ireland, i was merely interested in the weather? I've heard it rains alot........:p :p ;)

*mutters to self*
Yeah it does have a habit of raining from time to time. Suppose its something to do with us protecting you from the Atlantic ;)

Slap myself....
How could I forget! Well atleast Ireland is good for
something!!! ;) ;)

:p

Quote:

---

Originally posted by holly
Slap myself....
How could I forget! Well atleast Ireland is good for
something!!! ;) ;)

:p

---

*jamie ponders what britain's there for ....*

Hmmmm. Can't think of anything :confused:
;)

I'll leave that one with you....Its time to go home....;) ;) Nice
talking to you.....;) ;) ;) ;) ;) ;) ;) (plenty winks)