如何在MS Access中将显示控件从文本框更改为复选框 [英] How to change the display control from textbox to checkbox in ms access

问题描述

大家好，我需要代码来更改ms访问中lookup属性的显示控件.我知道手动，但我需要通过c#.net编码来完成.我的数据显示为-1表示true，0表示false.但是我需要复选框显示真或假.您可以派任何人解决此问题吗?

Hi every one i need code for change the display control for lookup property in ms access. I know manually but i need this to be do through the c#.net coding. My data is displaying like -1 for true and 0 for false. But i need checkboxes to display true or false. Can you send any one to solve this issue

推荐答案

我无法派任何人解决此问题，但是以下帮助可能对您有所帮助.

您可以使用查询更改它，并将其用于显示的控件.您为该列添加一个表达式(在字段中)并将其转换为该表达式.在下面的语句中，您需要用要转换的列的实际名称替换column.

I cannot send anyone to solve this issue but maybe the folowing could help you.

You can change it using a query and use that for the displayed control. You add an expression (in a field) for that column and convert it with that. In the statement below you need to replace column with the actual name of the column that you want to convert.

Expr1: IIf([column] = -1;TRUE;FALSE)

祝你好运！

Good luck!

这篇关于如何在MS Access中将显示控件从文本框更改为复选框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！