displaying zero's

[karlos]

in an access form i have there are are 6 rows where a
record be be entered. (6 invoice entries).

on each row there is a cost field where a number would be
entered.

my question is...how do you stop the zeros from showing if
an entry hasnt been enterered

so intsead of:

Product £3.90
Product £3.60
£0.00
£0.00

i would just want the first 2 rows showing the figures but
i dont want the zeros to show underneath

hope you understand

Karlos

 

[Karlos]

Changed the defaults so they were blank in the underlying
tables but the zeros are still showing (£0.00)

any other suggestions?

 

[karlos]

thanks for the reply peter but can you be a bit more
specific. what do you mean by controls. if you mean the
default value in the form itself (for the field) then that
is also blank. but its still displaying the zero's

 

[peter walker]

karlos
remove the default value from the underlaying table / query

--

peter walker MVP

Please post replies to the news group so everyone can benefit.
www.papwalker.com

in an access form i have there are are 6 rows where a
record be be entered. (6 invoice entries).

on each row there is a cost field where a number would be
entered.

my question is...how do you stop the zeros from showing if
an entry hasnt been enterered

so intsead of:

Product £3.90
Product £3.60
£0.00
£0.00

i would just want the first 2 rows showing the figures but
i dont want the zeros to show underneath

hope you understand

Karlos

 

[peter walker]

change the controls also

--

peter walker MVP

Please post replies to the news group so everyone can benefit.
www.papwalker.com

Changed the defaults so they were blank in the underlying
tables but the zeros are still showing (£0.00)

any other suggestions?