Change output on Form

[hext2003]

i have a sub form that tracks all changes made to the database. It shows the old value and the new values as well as which form and name of which field where changed and who made the changes.

I have several check boxes that show up as -1 old value and 0 new value. I know what these values mean but my users won't. What is an easy what to change this so it says yes or no or true false instead of -1 or 0?

I could code something, I was just wondering if there was a quick property somewhere that I could set...

TIA

 

[postermmxvicom]

Don't check boxes show up as checked or unchecked? Are they textboxes?

One last thing: Sometimes I wonder; "Is that someone's signature? Or do they type that at the end of each post?

 

[postermmxvicom]

If it is a textbox you can simply change the format of the control under the format tab on the property sheet to display true/false or yes/no or whatever

P.S. Sorry for two posts...should have made this one post

One last thing: Sometimes I wonder; "Is that someone's signature? Or do they type that at the end of each post?

 

[hext2003]

This is a Text Box field there is a text box that holds the Old Value and another text box that holds the New Value, sometimes it's a string, sometimes it's a number, sometimes it's a date and sometimes it's what happened to the the check box (ex Old Value Text box would say -1 and New Value would say 0 for this entry in the log (Does This make Sense??)

This is a history Log of all changes made in the database

I have looked at the properies of this field under the format tab ... and I am not sure how to set this.

Would I have to do an If statement?? If it's a Date, or String, or Number do nothing, if it's a check box say "Check Box ON" or "Check Box Off"

Sorry If how I worded this is confusing.

TIA

 

[postermmxvicom]

After playing around some, I only see this format option for text field with Yes/No fields as their sources. On text boxes with other things in them, the format option lists other options but not Yes/No, True/False etc...

I misunderstood you, and thought you had a text box bound to such a field.

I don't know if their is an easy way, but I am sure if there is the guys around here do know.

One last thing: Sometimes I wonder; "Is that someone's signature? Or do they type that at the end of each post?

 

[TheAceMan1]

How are ya hext2003 . . .
[ol][li]Remove the checkbox.[/li]
[li]Put an [blue]unbound textbox[/blue] in its place.[/li]
[li]Set the following properties for the textbox:
[ol a][li]Using the dropdown arrow in the [blue]control source[/blue] property, select the checkbox name.[/li]
[li]Enter the same name above in the [blue]name[/blue] property (be careful of spelling).[/li]
[li]Set the [blue]format[/blue] property to [blue]Yes/No[/blue].[/li][/ol][/li]
[li]Save & close the form.[/li]
[li][blue]Done! . . .[/blue][/li][/ol]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[postermmxvicom]

TheAceMan1,

I misread a lot of things around here, so I could really be way off base. But, in his second post he mentions that it is a text box. He also goes on to mention that it displays all kinds of things, not just -1 and 0. But he wants just the -1 and 0 to be formatted as Yes/No.

One last thing: Sometimes I wonder; "Is that someone's signature? Or do they type that at the end of each post?

 

[hext2003]

Thanks Aceman1 I think I understand how this would work. I'll Play with it later today and see if I can get it to work.

Postermmxvicom. Sorry I apologize for the confusion. I have a check box on a sub form. That can be turned off and on. I have a history log that I gather info about all changes made to any field in the db. So on the History Log is a Text box that need to get the old value of the check box. So I get a -1 or 0 in the text box on the history log from the check box field on a subform. I think what Aceman is telling me to try is change my Check Boxes to Text Boxes and then when it writes to my History Log it will write the value as YES/NO instead of -1/0