Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text conversion to numeric

Status
Not open for further replies.
ranshe

ranshe

Programmer
Oct 5, 2004
27
0
0
US
I have a text field on a form.
It is for entry of a number which I use in a calculation.
When I use it in an expression like Some_integer - Text1 it gives the message "Argument not optional and highlights Text1.
When I try the command data_numeric=Val(text1.text) it gives me an error saying "Method or data member not found and highlights: ".text". It does the same with CStr.
Both of these were suggested to me but i must not have the syntax down right.
data_numeric=Val(text1) doesn't work either.

Any suggestions?
 
Sort by date Sort by votes
It sounds like Text1 is not a textbox. To be sure, add this code to the form_load event and report back the results.

MsgBox TypeName(Text1)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Firstly, where do you have the code? Make sure it is in the code module that belongs to the Form.

Secondly, if VB gave you the second error then are you sure Text1 is a text box? It seems more likely that you are using a Label to me but then the first error would not make sense.

What you need to do is paste your code exactly as it is in your project.

Cheers
 
Upvote 0 Downvote
You could also look in your properties window for Text1, and it will tell you what type of control it is.

Bob
 
Upvote 0 Downvote
Well,
Don't ask me how, I guess i was up programming to late last night, but the Text1 had an Index set on it and was seeing it as Text1(2) and not as Text1. I should of noticed that but suffered from brain drain. When i tried "gmmastros" sugestion and put MsgBox TypeName(Text1) in the Load Form I discovered my problem because it did not find the name Text1.

Very sorry for wasting everyone's tome.

Thanks anyway.
It did help though.
 
Upvote 0 Downvote
ahh we should have been able to work that out from the symptoms! Drat

It was clear that it was not a text box but why would a label be called a named Text1? That's why I was suspect of my guess. I never thought of an index on the control :)
 
Upvote 0 Downvote
I'm glad that my suggestion, while not completely on mark, did lead you to discovering your problem for yourself.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Date/Time Conversion 1
Replies
2
Views
105
Swi
Swi
sal21
  • Locked
  • Question
Check of valute change in text file 3
Replies
15
Views
305
strongm
strongm
Swi
  • Locked
  • Question
IMB - USPS Barcode Conversion
Replies
2
Views
113
Swi
Swi
2009luca
difficult to crteate a query very complicated 1
Replies
9
Views
825
Andrzejek
Andrzejek
2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
187
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top