Is it possible to have a bound textbox formatted as numeric where a user can enter a new value, something like "+10" and textbox shows the current value +10 as the new textbox value?
Also if the dont enter the "+", it just overwrites the value?
Is it possible to have a bound textbox formatted as numeric where a user can enter a new value, something like "+10" and textbox shows the current value +10 as the new textbox value?
Also if the dont enter the "+", it just overwrites the value?
If "bound" and "formatted as numeric" means textbox is bound to a number type field, answer is "no".
On second thought, if resulting error can be trapped in VBA then could possibly read the current input value and the old value and adjust field value accordingly. But I suspect this will fail because number field simply cannot accept non-numeric input and likely this is not a VBA trappable error.
Provide unbound textbox for user input and VBA would manage adjusting field value.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Value and OldValue are properties of textbox. Code in textbox BeforeUpdate event can grab old value and new value and add them and set field value.
Why would you want this?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
What does "add" mean here?
If it contained 10 and I enter 10, the result is 10+10? 20? 1010? Something else?
The only way you can do #1 or #3 is to use a text field.
Or do you want to format/display my 10 entry as +10?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.