How to blank a selected field for input

[Guest]

This seems a very basic question (I seem to spend a disproportionate amount
of time on annoyingly simple requirements).

I have an input form showing multiple records, one line per record. When the
user selects an input field text box (to input a currency amount) which is
bound to a currency field which starts with a value of zero, a zero is shown
inside the box rather than blank so the user has to delete this zero before
entering the value. Tabbing to the field works ok but the user must select
non-sequential records to update by clicking in the required record so
tabbing is not an option.

I've tried setting a custom format for the field as $0.00;($0.00)[Red];#;
but Despite the # in the zero specification in this format a zero still
displays when the user clicks in the field. This is a data entry form and
having to clear the zero is time consuming when a lot of data is being input.

 

[Rick Brandt]

This seems a very basic question (I seem to spend a disproportionate
amount of time on annoyingly simple requirements).

I have an input form showing multiple records, one line per record.
When the user selects an input field text box (to input a currency
amount) which is bound to a currency field which starts with a value
of zero, a zero is shown inside the box rather than blank so the user
has to delete this zero before entering the value. Tabbing to the
field works ok but the user must select non-sequential records to
update by clicking in the required record so tabbing is not an option.

I've tried setting a custom format for the field as
$0.00;($0.00)[Red];#; but Despite the # in the zero specification in
this format a zero still displays when the user clicks in the field.
This is a data entry form and having to clear the zero is time
consuming when a lot of data is being input.

Either the field in the table's design, the TextBox on the form, or both have
zero as a default value. Just delete that and the zero will stop appearing.

By default Access makes zero the default for all numeric fields in tables.