number field

[DevAccess]

Hello

How to create a number field on form which would accept only numberic value ?

Thanks

 

[Minty]

If the control is bound to a number field it will only accept a number.

If it's unbound have a look at the IsNumeric() function in the before update event of the control.

 

[DevAccess]

If the control is bound to a number field it will only accept a number.

If it's unbound have a look at the IsNumeric() function in the before update event of the control.

Thanks Minty, I would like to create a computed field which would do calculaton based on above two field what kind of field I have to create ?

May be like this

Field1 - field 2 result of this would be displayed in one of the field.

 

[Minty]

If it's computed then by setting it's control source to [Control1] - [Control2] you won't be able to update or edit it anyway. Set the default values of the controls to 0 to avoid an error display.

 

[DevAccess]

If it's computed then by setting it's control source to [Control1] - [Control2] you won't be able to update or edit it anyway. Set the default values of the controls to 0 to avoid an error display.

I am trying to refer combox values in expression builder it gives me ID value instead of actual value it is holding , Can you please tell me what is wrong here ?

 

[Minty]

That sounds like you have lookup fields in your tables - they are not good news. http://access.mvps.org/access/lookupfields.htm