将查找列显示为字符串，而不是数字 [英] Displaying lookup columns as string, not numerics

问题描述

我的查找表出现问题。当我在Excel表格中显示数据时，查找字段中的结果显示为数字代码而不是字符串。我们希望显示实际的字符串数据而不是数字代码;我怎么能改变这个？我们正在使用Access 2000.


谢谢，

Tonya


PS - 我在2中创建了查找不同的方式，因此查找的行源类型包括值列表和表/查询。

Hi,
I am having issues with my lookup tables. When I display the data in an Excel table, the results in the lookup fields appear as the numeric codes rather than in string. We wish to display the actual string data rather than the numeric codes; how can I change this? We are using Access 2000.

Thanks,
Tonya

PS - I have created the lookups in 2 different ways, so the Row Source Type of the lookups include both Value Lists and Table/Query.

推荐答案

您已在文章部分发布此内容。


我正把它移到Access论坛。


ADMIN

You have posted this in the Articles section.

I am moving it to the Access forum.

ADMIN

道歉 - 感谢你搬家。

Tonya

Apologies - thanks for moving this.
Tonya

我的查找表出现问题。当我在Excel表格中显示数据时，查找字段中的结果显示为数字代码而不是字符串。我们希望显示实际的字符串数据而不是数字代码;我怎么能改变这个？我们正在使用Access 2000.


谢谢，

Tonya


PS - 我在2中创建了查找不同的方式，因此查找的行源类型包括值列表和表/查询。

Hi,
I am having issues with my lookup tables. When I display the data in an Excel table, the results in the lookup fields appear as the numeric codes rather than in string. We wish to display the actual string data rather than the numeric codes; how can I change this? We are using Access 2000.

Thanks,
Tonya

PS - I have created the lookups in 2 different ways, so the Row Source Type of the lookups include both Value Lists and Table/Query.

Tonya，

您可能想尝试更清楚地解释一下。

那里''没有迹象表明这一切都与此有关。我认为你的工作方式不同，但这就是我能得到的。

Tonya,
You may want to try to explain this a little more clearly.
There''s no indication what this all relates to. I presume you''re working in a form but that''s about as far as I can get.

这篇关于将查找列显示为字符串，而不是数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！