Display Problem

[Frank]

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.

 

[Pat Hartman]

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

display, I don't know how can do it. such as ******7687.
Thank you.

 

[John Vinson]

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.

Set the Control Source of the textbox to

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

The field will, of course, not be editable.