Table Data Type for Option Group controls on Forms?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I originally gave some fields a 'Combo Box' Data type (w/ a Row
Source type of 'Value List') on the underlying table, but given the nature of
the data entry form I had to emulate, found that an Option Group suited my
needs on the form best. As you define the numerical values and their
associated form labels as you set up the Option Group, is it better to have
the Data type in the underlying field be 'Text Box' instead of 'Combo Box'?
Will it impact the accuracy of the data in the table?

Thanks,
 
Pat Dools said:
Hello, I originally gave some fields a 'Combo Box' Data type (w/ a Row
Source type of 'Value List') on the underlying table, but given the nature of
the data entry form I had to emulate, found that an Option Group suited my
needs on the form best. As you define the numerical values and their
associated form labels as you set up the Option Group, is it better to have
the Data type in the underlying field be 'Text Box' instead of 'Combo Box'?
Will it impact the accuracy of the data in the table?
Click to expand...

In a table a field is a field and every field has a DataType (Number, Text,
DateTime, etc.). The concept of TextBox and ComboBox doesn't apply to a table
except to support the ill-advised "mis-feature" that is a lookup field. Your
form doesn't care one bit which setting is used in that regard.
 
Back
Top