组合框行源 [英] Combo Box Row Source

问题描述

我使用以下SQL作为表单上组合框的RowSource。


SELECT LAN，TenantName作为[租户名称]，ShopNum作为[Shop] FROM

qTenantSelect"


字段''ShopNum''是一个文本字段，其标题属性设置为''Shop
$ b表格设计中的$ b数字''

但在组合框中，我想使用''Shop'作为标题（以节省宽度）

as在上面的SQL中显示。

但组合在表单视图中显示商店号码作为标题。


我认为''作为商店''会做我想做的，但看起来像

我错了......又来了。


有人可以帮忙吗？ br />

-

Bob Darlington

布里斯班

解决方案

Bob，

据我所知，标题只是一个标签，可以重新命名为

please。它显示''商店编号''，因为无论你称之为AS，

来源仍然是''商店编号''。

显示为组合框细节的数据应该是没有

标题的原始数据。如果您对列宽不满意，可以在组合框属性中更改

。 列宽中的值为列宽。在

"格式"选项卡是您需要更改的值。参见Columnwidth和Columnwidth。物业

在Access帮助中获取详细信息。


Rgds，


Mark

" Bob Darlington" < bo*@dpcmanAX.com.au>在留言中写道

news：41 *********************** @ news.optusnet.com.a u ... < blockquote class =post_quotes>我使用以下SQL作为表单上组合框的RowSource。

SELECT LAN，TenantName as [Tenant Name]，ShopNum as [Shop] FROM
qTenantSelect"

字段''ShopNum''是一个文本字段，并且在表格设计中将标题属性设置为
''Shop Number''。但是在组合框中，我想使用''Shop'作为标题（以节省
宽度），如上面的SQL所示。
但组合显示''商店号'''作为形式视图中的标题。

我认为''As Shop''会做我想做的事，但看起来像我错了......但又一次。

任何人都可以帮忙吗？

- 鲍勃达林顿
布里斯班

只需更改标题即可。标签的属性，无论你想要什么，

。 。 。

" Bob Darlington" < bo*@dpcmanAX.com.au>在留言中写道

news：41 *********************** @ news.optusnet.com.a u ... < blockquote class =post_quotes>我使用以下SQL作为表单上组合框的RowSource。

SELECT LAN，TenantName as [Tenant Name]，ShopNum as [Shop] FROM
qTenantSelect"

字段''ShopNum''是一个文本字段，并且在表格设计中将标题属性设置为
''Shop Number''。但是在组合框中，我想使用''Shop'作为标题（以节省
宽度），如上面的SQL所示。
但组合显示''商店号'''作为形式视图中的标题。

我认为''As Shop''会做我想做的事，但看起来像我错了......但又一次。

任何人都可以帮忙吗？

- 鲍勃达林顿
布里斯班

它不是标签。标题属性在表格设计中，并且按照预期在整个应用程序中使用

。

但对于这个特定的组合，我想将其更改为更短的内容 -

因此''作为''。


-

Bob Darlington

布里斯班
" Ed Sturges" < ES ******** @ snet.net>在消息中写道

news：dw ***************** @ newssvr17.news.prodigy.co m ...

只需更改标题即可标签的属性，无论你希望它是什么。 。 。

" Bob Darlington" < bo*@dpcmanAX.com.au>在消息中写道
新闻：41 *********************** @ news.optusnet.com.a u ...

我使用以下SQL作为表单上组合框的RowSource。

SELECT LAN，TenantName作为[租户名称]，ShopNum作为[Shop] FROM
qTenantSelect"

字段''ShopNum''是一个文本字段，其标题属性设置为

''Shop

Number' '在表格设计中。
在组合框中，我想使用''Shop'作为标题（保存

宽度）

as在上面的SQL中显示。
但组合在表单视图中显示商店号码作为标题。

我认为''As Shop''会做我所做的事情想要，但看起来

喜欢

我错了......又一次。

任何人都可以帮忙吗？

-
Bob Darlington
布里斯班

I am using the following SQL as a RowSource for a combo box on a form.

"SELECT LAN, TenantName as [Tenant Name], ShopNum as [Shop] FROM
qTenantSelect "

The field ''ShopNum'' is a text field and has a caption property set to ''Shop
Number'' in the table design.
In the combo box though, I want to use ''Shop'' as the heading (to save width)
as shown in the SQL above.
But the combo shows ''Shop Number'' as a heading in form view.

I thought that the ''As Shop'' would have done what I wanted, but looks like
I''m wrong .... yet again.

Can anyone help?

--
Bob Darlington
Brisbane

解决方案

Bob,
As far as I know, the heading is just a label and can be renamed as you
please. It displays ''Shop Number'' because whatever you call it AS, the
source is still ''Shop Number''.
The data displayed as the combo box detail should be the raw data with no
headings at all. If you are not happy with the column widths, you can change
them in the combo box properties. The values in "Column widths" on the
"Format" tab are the values you need to change. See "Columnwidth" property
in Access help for full details.

Rgds,

Mark

"Bob Darlington" <bo*@dpcmanAX.com.au> wrote in message
news:41***********************@news.optusnet.com.a u...

I am using the following SQL as a RowSource for a combo box on a form.

"SELECT LAN, TenantName as [Tenant Name], ShopNum as [Shop] FROM
qTenantSelect "

The field ''ShopNum'' is a text field and has a caption property set to ''Shop Number'' in the table design.
In the combo box though, I want to use ''Shop'' as the heading (to save width) as shown in the SQL above.
But the combo shows ''Shop Number'' as a heading in form view.

I thought that the ''As Shop'' would have done what I wanted, but looks like I''m wrong .... yet again.

Can anyone help?

--
Bob Darlington
Brisbane

Simply change the "Caption" property for the label to whatever you wish it
to be . . .
"Bob Darlington" <bo*@dpcmanAX.com.au> wrote in message
news:41***********************@news.optusnet.com.a u...

I am using the following SQL as a RowSource for a combo box on a form.

"SELECT LAN, TenantName as [Tenant Name], ShopNum as [Shop] FROM
qTenantSelect "

The field ''ShopNum'' is a text field and has a caption property set to ''Shop Number'' in the table design.
In the combo box though, I want to use ''Shop'' as the heading (to save width) as shown in the SQL above.
But the combo shows ''Shop Number'' as a heading in form view.

I thought that the ''As Shop'' would have done what I wanted, but looks like I''m wrong .... yet again.

Can anyone help?

--
Bob Darlington
Brisbane

It is not a label. The caption property is in the table design, and is used
throughtout the app as intended.
But for this particular combo, I want to change it to something shorter -
hence ''As''.

--
Bob Darlington
Brisbane
"Ed Sturges" <es********@snet.net> wrote in message
news:dw*****************@newssvr17.news.prodigy.co m...

Simply change the "Caption" property for the label to whatever you wish it
to be . . .
"Bob Darlington" <bo*@dpcmanAX.com.au> wrote in message
news:41***********************@news.optusnet.com.a u...

I am using the following SQL as a RowSource for a combo box on a form.

"SELECT LAN, TenantName as [Tenant Name], ShopNum as [Shop] FROM
qTenantSelect "

The field ''ShopNum'' is a text field and has a caption property set to

''Shop

Number'' in the table design.
In the combo box though, I want to use ''Shop'' as the heading (to save

width)

as shown in the SQL above.
But the combo shows ''Shop Number'' as a heading in form view.

I thought that the ''As Shop'' would have done what I wanted, but looks

like

I''m wrong .... yet again.

Can anyone help?

--
Bob Darlington
Brisbane

这篇关于组合框行源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！