If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Display Problem
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. -- Frank Chen |
#2
|
|||
|
|||
Display Problem
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. -- Frank Chen . |
#3
|
|||
|
|||
Display Problem
On Tue, 6 Jul 2004 10:50:01 -0700, "Frank"
wrote: 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. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
problem with an error | evil_one | General Discussion | 7 | June 17th, 2004 09:27 PM |
Problem with Outlook Today and Displaying Multi-Day Events | richr1964 | Calendar | 0 | June 10th, 2004 04:48 PM |
Unable to display the folder. The calendar folder could not be found. | rex | Calendar | 0 | May 26th, 2004 04:58 PM |
Address book display problem | J.D. Goff | Contacts | 0 | April 26th, 2004 02:55 PM |