how to set unbound textbox as numeric ???

accesscomthomas

Registered User.
Local time
Today, 14:41
Joined
Jul 30, 2004
Messages
26
hello,

I need to use the numeric value in a unbound textbox in the WHERE clause of query .... how could I set a UNBOUND TEXTBOX as NUMERIC ??? :confused:

thanks
 
could you be nice enough to tell me which properties ?
i can't find anything like "type"
 
Under Format you will find a multitude of options.

Everything except Text of course

You can also use Decimal Places and Input mask to further define

HTH

Len B
 
oh ... that means , if i set the Decimal places , the .Value of a textbox will become numeric but not text ?
 
Basically the answer is Yes.

If a field within a table is defined as text then it is text. An unbound value can be interpreted in a variety of ways as you have seen

Curious. Why do you need this unbound field ?.

L
 
thanks for your answer ;)

in fact, i had a wrong design (trying to use an unbound textbox in a form to manage numeric fields across tables) . The problem was solved by creating the form on a query such that all the numeric fields are included and bound in the form

Thanks again :)
 
what's "FYI controls" ???

anyway, i found that DSum() should be used instead of action query in my case.
 
accesscomthomas said:
what's "FYI controls" ???

For your information, Controls are Variants.

This means their data type (Variant) can hold different types of data type: numbers, text, currency, single, etc.

Therefore, for your WHERE clause, all you need is to use

[Forms]![MyForm]![MyControl]

in your query criteria.
 

Users who are viewing this thread

Back
Top Bottom