Empty Fields in Forms

  • Thread starter Thread starter Teddyboy
  • Start date Start date
T

Teddyboy

I have set up a form to with up to 7 names of persons thay
may be in a group together with other data fields of each
that appear in small 'windows' - where there is no name or
data in a field the 'window' for that field shows
something like @???? or #???? (can't remember exactly
what) - HOW can I make these 'windows' appear just blank?.
An example is one group may only have 4 members so 3 of
the name boxes should be blank.
 
I have set up a form to with up to 7 names of persons thay
may be in a group together with other data fields of each
that appear in small 'windows' - where there is no name or
data in a field the 'window' for that field shows
something like @???? or #???? (can't remember exactly
what) - HOW can I make these 'windows' appear just blank?.
An example is one group may only have 4 members so 3 of
the name boxes should be blank.
Click to expand...

What's the Recordsource of the form? What are the Control Source
properties of these controls?

Just a note - if you have seven name fields in one table, you may want
to consider "normalizing" your data: it's bad design to have a one to
many relationship embedded within a single record. Especially if the
same names turn up in multiple records (a many to many relationship),
you will probably be better off with two or three tables.
 
Back
Top