472,779 Members | 1,989 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,779 software developers and data experts.

Default Value for a field

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
4 2187
"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

Thanks

Jul 25 '06 #3
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
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: akl | last post by:
How can I create such a default value that it depends on the value in other field (drop down)? So that the default value would be updated every time I change the value of drop-down field.
2
by: Terry Bickle | last post by:
Please forgive me for using the wrong term here or there. I'm an old Excel 4 macro guy who didn't convert to VB and I'm tinkering with an Access 2000 DB. I'm sure there is a simple Access 101...
10
by: MLH | last post by:
I have an A97 table with a Yes/No field named TowJob and a form bound to that table. The TowJob control on the form is bound to the same field. It is an option group with Yes and No bttns valued...
3
by: Scott Liu | last post by:
HI, All, I have a web service doing a string search. It has an operator and a searchValue field. The operator is defined as an attribute and required. The xml is as below. <!--...
5
by: HandersonVA | last post by:
should I set to "0" as a default value on a quantity and a price field or set to "null"? if a user enter nothing on the quantity or price field on a web browser, should I treat it as null or "0"?...
6
by: carmela_wong | last post by:
Hello all, I am trying to set the default value of a combo box to "USA" which does not work although I have entered this in the Default Value property of the control. The combo box shows the...
2
by: mukesh | last post by:
Can we use expression in default value for a table field for example IIf(Table-1.field-1=table-2 . field-1, table-1.field-2, 0) Interpretation If field-1 of table -1 is like/equal to...
74
by: Zytan | last post by:
I have a struct constructor to initialize all of my private (or public readonly) fields. There still exists the default constructor that sets them all to zero. Is there a way to remove the...
4
by: helenwheelss | last post by:
Access 2003, using a bound form. I'm seeing rather annoying behaviour when editing data in a control with a default value. It only happens when the form is on a new record. A specific...
4
by: Macneed | last post by:
i am a newbie, i remember i read a book talking about when u declare a array variable using float ABC = new float; the whole array element in ABC ( ABC to ABC ) will automatic initialize to 0...
0
by: Rina0 | last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: lllomh | last post by:
How does React native implement an English player?
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.