 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / January 2005How do I create an option group in table?
I created an option group with three choices in form design view; the option group is not shown in the table view. I did create a check box in table design for that field. Please help me create the option group to display in both form and table views. Thank you in advance, hrman You can't in table-view. Table view displays the records in a TABLE VIEW. How could you show an option group (a box) in a TABLE VIEW? > I created an option group with three choices in form design view; the option > group is not shown in the table view. I did create a check box in table [quoted text clipped - 3 lines] > Thank you in advance, > hrman > I created an option group with three choices in form design view; the option > group is not shown in the table view. I did create a check box in table [quoted text clipped - 3 lines] > Thank you in advance, > hrman Change that check box field in the table to Number datatype, field size Integer. On the form, make that field the Control source for the Option Group. The Table field will store the selected value of the group as a number value. You can display the number value as text, in a report for instance, using an unbound control. Set it's control source to: =Choose([OptionField],"Text1","Text2","Text3") etc.  SignatureFred Please only reply to this newsgroup. I do not reply to personal email. >I created an option group with three choices in form design view; the option >group is not shown in the table view. I did create a check box in table >design for that field. Please help me create the option group to display in >both form and table views. You cannot. Table datasheets are of VERY limited utility. They are not designed as data entry or editing tools. In particular, table datasheets do not allow the use of Option Group controls for display. A Table is a data *storage* object. A form is a data *display* object. They are different kinds of objects, for different purposes. John W. Vinson[MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.