Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 152
  • Last Modified:

DDL Question: How do I set the format Property of a field

I am using ADO to create tables, fields & relationships etc., I have created a field called Archived which I created as a boolean (Yes/No). How do I then set this fields format property to TRUE/FALSE???

Any code would be a help

Thanx in advance


Mick
0
mickdoherty
Asked:
mickdoherty
1 Solution
 
TimCotteeHead of Software ServicesCommented:
Mick, is this an access database?
0
 
CJ_SCommented:
use the 0 and 1's.

regards,
CJ
0
 
planoczCommented:
The field called Archived will automatically be false.
as you access the field you can change it to true if needed.

0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
mickdohertyAuthor Commented:
Tim, Yes this is an Access database!

CJ, Do you mean use 0 and 1's in my vb program.?
e.g. rs![Archived] = 1  or rs![Archived] = 0
If so... can't do that!!!

Planocz, Go back to sleep. I don't want know how to set the DefaultValue! Even if that's what your talking about???


Mick
0
 
planoczCommented:
Sense I'm asleep try this code...
 
    Select Case rs![Archived]
        Case True
             rs.Update "Archived", False
        Case False
             rs.Update "Archived", True
      End Select
0
 
DanRollinsCommented:
Hi mickdoherty,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept CJ_S's comment(s) as an answer.

mickdoherty, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0
 
NetminderCommented:
Per recommendation, force-accepted.

Netminder
CS Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now