0.00 in form fields

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

Access 97
I have several fields defined as either number or currency.
I also have code to calculate.
The problem is when the user Tabs into the numeric or
currency field in the form, the cursor automatically goes
to the right of the pre-existing zeroes. So the user has
to backspace before typing into the field. Is there a way
to just have the whole field 'selected' so that whatever
they type replaces it?
Thanks alot
Sue
 
I know that you can choose the behavior of the cursor in
the Access options menu (Tools>Options>Keyboard>Behavior
Entering Field)
You could not have a default of 0 in that field and use
code in the After_Update event of the form to enter a
zero for the field if nothing was entered (that could
give you undesired results though)
I know of no text box property in A97 nor programatic way
to affect how you enter the control when tabbing. The
user can always set their options to select Select Entire
Field when entering a control, if they use this database
most often.
 
Use the Menu Tools / Options ... / Keyboard tab / "Behaviour entering field"
pane and select whichever option you want.
 
Back
Top