Hiding textbox content with "******"

[Lifeseeker]

Hi,

I have a field in the database that stores identifiable information.

So on the form, is it possible to create some kind of "cover" to hide what's in that field?

The field stores 10-digit number(however, the data type could be text-based), but I would like the field to show the content as "*******" on the form.

When exporting records into Excel, we would like to see the actual 10-digit number.

Can this be done in Access 2003?

Comment/thoughts much appreciated.

 

[MarkK]

If the control will not show meaningful information why is it on the form?

 

[boblarson]

but if you have to have it on the form (I agree with lagbolt on this - why have it there if you can't see it anyway?) you can set the input mask to Password and it should obscure it.

 

[Lifeseeker]

but if you have to have it on the form (I agree with lagbolt on this - why have it there if you can't see it anyway?) you can set the input mask to Password and it should obscure it.

Hi,

I guess I can go with the Input Mask option.

When exporting into Excel, will the output show the original 10-digit?

 

[boblarson]

Hi,

I guess I can go with the Input Mask option.

When exporting into Excel, will the output show the original 10-digit?

Yes it will.