By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,210 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Default Value for a field

P: n/a
Hello

I am trying to setup a default value for a field in a form. The field
is a text box. I need to setup the default value to: 0.000. And
whenever the user is trying to enter a value for this field, using the
form, he ONLY can enter a value with that structure (0.000). eg. 1.234,
1.345, 6.543, 1.040, 0.003, 0.434. Can somebody tell me how to do this
please???

I know there is a default value option under the properties of the
texbox, where I can put like =0 and the form will load with the 0 in
the textbox. But I want to see 0.000. I was thinking on maybe valiation
rule?? need helpp

thanks

Jul 24 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"erick-flores" <ch**********@hotmail.comwrote in
news:11*********************@m73g2000cwd.googlegro ups.com:
Hello

I am trying to setup a default value for a field in a form.
The field is a text box. I need to setup the default value to:
0.000. And whenever the user is trying to enter a value for
this field, using the form, he ONLY can enter a value with
that structure (0.000). eg. 1.234, 1.345, 6.543, 1.040, 0.003,
0.434. Can somebody tell me how to do this please???

I know there is a default value option under the properties of
the texbox, where I can put like =0 and the form will load
with the 0 in the textbox. But I want to see 0.000. I was
thinking on maybe valiation rule?? need helpp

thanks
The correct answer is e) None of the Above.

What you want is an input mask. That's the second row on hte
data tab of the properties menu.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Jul 24 '06 #2

P: n/a

Thanks

Jul 25 '06 #3

P: n/a
When I try to enter 32.234, 234.345, 3443.806 and the Input Mask:
0.000, of course it wont let me enter more than one (1) number in the
"0."
If I put Input Mask: 0000.000 then I must enter four (1234.) numbers
for the "0000." I know you know this, but my question is how can I set
the Input Mask so I wont get this problem. I want the field to be
flexible for either enter one or multiple numbers before the " .000"

Any ideas?

Jul 25 '06 #4

P: n/a
"erick-flores" <ch**********@hotmail.comwrote in
news:11*********************@m79g2000cwm.googlegro ups.com:
When I try to enter 32.234, 234.345, 3443.806 and the Input
Mask: 0.000, of course it wont let me enter more than one (1)
number in the "0."
If I put Input Mask: 0000.000 then I must enter four (1234.)
numbers for the "0000." I know you know this, but my question
is how can I set the Input Mask so I wont get this problem. I
want the field to be flexible for either enter one or multiple
numbers before the " .000"

Any ideas?
Insert your cursor into the input mask entry field. Press F1.
Read the help.
Here is a portion of the help for input mask

0 Digit (0 to 9, entry required, plus [+] and minus [-] signs
not allowed).
9 Digit or space (entry not required, plus and minus signs not
allowed).
# Digit or space (entry not required; spaces are displayed as
blanks while in Edit mode, but blanks are removed when data is
saved; plus and minus signs allowed).

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Jul 25 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.