How to change the display control from textbox to checkbox in ms access

Question

0.00/5 (No votes)

See more:

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

Posted 17-Mar-11 1:36am

janablisslogix

Add a Solution

Comments

Rajesh Anuhya 17-Mar-11 8:05am

Your Question is not clear for me.., can you elaborate it more...

janablisslogix 17-Mar-11 8:45am

just i want to change the ms access column field properties. It has one property named as Display control. In my database the display control is textbox but i need the display control is check box. i can do this job manually in ms access. But i want this through the c#.net code with one function in button click.

and my code is

string Path1 = System.Windows.Forms.Application.StartupPath +"\\CANASIA TOYS & GIFTS PRODUCTS.mdb";
DAO.Field Field = new DAO.Field();
DAO.TableDef tbldef = new DAO.TableDef();
DAO.Property tblpro;
DAO.DBEngine dbeng = new DAO.DBEngine();
DAO.Database db;
db = dbeng.OpenDatabase(Path1, false, false, "");
tbldef = db.TableDefs["PRODUCTS"];
Field = tbldef.Fields["NewRelease"];
tblpro = Field.CreateProperty("DisplayControl", DAO.DataTypeEnum.dbBoolean, false, true);
tbldef.Properties.Append(tblpro);

but it is not working

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

E.F. Nijboer · Accepted Answer · 2011-03-17T02:49:00

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.

VB

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

Good luck!