MS Access:在组合框中显示两列 [英] MS Access: Display two columns in combo-box

问题描述

令人尴尬的问题，但我无法解决，也无法通过Google找到答案.

Embarrassingly simple question but I can't work it out or find the answer via google.

有两个柱子这样的东西

但是，当选择只显示一列，使得信息更难读/理解.

But when selected it only displays one column, making the information much harder to read/ understand.

试图更改属性表中的属性(例如列号)，但没有明显效果.

Tried changing properties in property sheet (such as column number) but to no apparent effect.

推荐答案

在某种程度上取决于您的工作，通常适合以下情况:

It depends to a certain extent on what you are doing, often something like this suits:

SELECT Id, Surname & ", " & Forename from Table

换句话说，绑定列是唯一ID，选择列在同一列中包含姓氏和姓氏.

In other words, the bound column is a unique ID and the selection column includes both the surname and forename in a single column.

根据其他信息进行

SELECT [Contact].[CID], [Contact].[Csname] & ", " & [Contact].[Cfname] 
FROM [Contact] ORDER BY [CID], [Csname], [Cfname];

这篇关于MS Access:在组合框中显示两列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！