Option buttons

  • Thread starter Thread starter huzefahashim
  • Start date Start date
H

huzefahashim

Hi,
I have option buttons in my forms where the user can select either one
of two i.e. Confirmed or Dropped.
When the user selects one, the value in the table comes to either 1 or
2.
How can I make sure that the actual text shows up in the table rather
than the value?

Thanks,
Zef.
 
An option group can only be bound to a Number field.

If you wish to store text, use a combo box.

Alternatively, you could create a lookup table that has a Number column
(primary key) and a Text column. The text explains the number. You can then
use the text in your reports (by creating a query that includes both
tables.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting image link to the table 1
Let user choose currency 1
Query Parameter using multiple options 0
Create report only for last record 1
Assigning values to text for calculation 0
Option Button Question 2
Option Buttons 5
Navigation Control - How to Set the Highlighted Tab 1

Back
Top