Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Money textbox
Message
From
05/05/2005 07:33:45
 
 
To
05/05/2005 07:25:06
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01011208
Message ID:
01011211
Views:
12
>Hi all,
>
>I have 3 questions about the following:
>
>I have a form with a textbox. In this textbox the user must typ a money amount. (format: 999,99) Then before I save this amount in a table I have to check if the user really typed the amount.
>
>Question 1: How can I check if the textbox doesn't have the value: 0,00 ?
>
>Question 2: How can I set the right format for the textbox, so you can type money amounts in it?
>
>Question 3: With which command can I save the typed amount in my table?
>
>I really hope somebody can help me out...
>
>Thanks in Advance
>Ron

1. If EMPTY( thisform.txtMoney.value)
or
If thisform.txtMoney.value = 0

2. See Format, MaxLength and InputMask properties.

e.g. Format => R
InputMask => ###,##9
MaxLength => 6
It would help, I guess, if the field is data type Currency

3. The field at which you input the amount is bound to the value in your table. Save the record in your normal way (e.g. if using buffering, via TableUpdate()

HTH

Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform