Need a way to show a work in a form after verify the status in a T

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I had a table with a list of check. That table has a yes/no field attach to
a check box in a form. The check box is to specify if the transaction(check)
was cashed by the bank.

I want to add a field in a different form for serching purposes to show a
message if the check was cashed or not. Right now the search looks for the
table I just need a way to show a message after the search with the status.
Like Cashed!

Thank you all!!!
 
A Yes/No field is really a boolean field, Yes/No is just a away of formatting
the output. This means that you can also format it in any other fashion that
you wish. For your purpose a format property such as this may suit:

;"Cashed"[Blue];"Not Cashed"[Red]

HTH
John
 
This would help for now but, what I was thinking is like a flashing message
in the form after the search returns the value as cashed or not cashed.

By the way, where should I use this property.

Thenks :-)

John Smith said:
A Yes/No field is really a boolean field, Yes/No is just a away of formatting
the output. This means that you can also format it in any other fashion that
you wish. For your purpose a format property such as this may suit:

;"Cashed"[Blue];"Not Cashed"[Red]

HTH
John

jeannette_rivera said:
I had a table with a list of check. That table has a yes/no field attach to
a check box in a form. The check box is to specify if the transaction(check)
was cashed by the bank.
I want to add a field in a different form for serching purposes to show a
message if the check was cashed or not. Right now the search looks for the
table I just need a way to show a message after the search with the status.
Like Cashed!
Thank you all!!!
 
Use this as the format property of the control on your form. You *can* make
controls flash, provided that you are not using a list form (all records flash
together). Having said that I find that it tends to annoy users, and if you
get the frequency wrong can be dangerous to anyone with epilepsy. Also, it
needs a timer event to make it work which can sometimes cause problems with
other code. This is why I offered the Red/Blue highlighting. A compromise
that I have used is to put a coloured border around a field that I need to
draw attention to, flash it two or three times and then leave it visible.

John

jeannette_rivera said:
This would help for now but, what I was thinking is like a flashing message
in the form after the search returns the value as cashed or not cashed.
By the way, where should I use this property.
Thenks :-)
John Smith said:
A Yes/No field is really a boolean field, Yes/No is just a away of formatting
the output. This means that you can also format it in any other fashion that
you wish. For your purpose a format property such as this may suit:
;"Cashed"[Blue];"Not Cashed"[Red]

jeannette_rivera said:
I had a table with a list of check. That table has a yes/no field attach to
a check box in a form. The check box is to specify if the transaction(check)
was cashed by the bank.
I want to add a field in a different form for serching purposes to show a
message if the check was cashed or not. Right now the search looks for the
table I just need a way to show a message after the search with the status.
Like Cashed!
 
Back
Top