Display Problem

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

Guest

Hi There,

I try to hide a part of text data in Access form when it display, I don't know how can do it. such as ******7687. Thank you.
 
Each control contains only a single set of properties so
you can't use the password format to hide part of a
field. What you can do is to add a second unbound field
with a ControlSource of
=Right(YourFieldName,4)
So in your bound field, the complete value is hidden but
in the unbound field, the last 4 characters are displayed.
-----Original Message-----
Hi There,

I try to hide a part of text data in Access form when it
Click to expand...
display, I don't know how can do it. such as ******7687.
Thank you.
 
Hi There,

I try to hide a part of text data in Access form when it display, I don't know how can do it. such as ******7687. Thank you.
Click to expand...

Set the Control Source of the textbox to

= "******" & Right([fieldname], 4)

The field will, of course, not be editable.
 
Back
Top