pull-down menu in Access forms - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

pull-down menu in Access forms

pull-down menu in Access forms# Database - 数据库

j*t2004-09-20 07:09

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*t2004-09-20 07:09

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.