j******t 发帖数: 11 | 1 how can i specify the options in a pull-down menu in Access forms? right now
i only know that if the options are entered and stored in the table, they'll
be shown in the pull-down menu. is there a way to add in those options
without manually entering them in the table beforehand?? many thanks. | j******t 发帖数: 11 | 2 finally figured it out by myself. answer my own question here in case that
somebody else may find it helpful:
1. under form design view, highlight the box which we want it to be a
pull-down menu, right click to prompt the window and choose "Change
To"-->"Combo Box".
2. in the same window, click "Properties" at the bottom. on "Data" page,
choose "Value List" for "Row Source Type", and type in all the values in "Row
Source", using quotation mark and semicolon to seperate each of them.
now
【在 j******t 的大作中提到】 : how can i specify the options in a pull-down menu in Access forms? right now : i only know that if the options are entered and stored in the table, they'll : be shown in the pull-down menu. is there a way to add in those options : without manually entering them in the table beforehand?? many thanks.
|
|