A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Display Problem



 
 
Thread Tools Display Modes
  #1  
Old July 6th, 2004, 06:50 PM
Frank
external usenet poster
 
Posts: n/a
Default 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  
Old July 6th, 2004, 08:52 PM
Pat Hartman
external usenet poster
 
Posts: n/a
Default 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  
Old July 6th, 2004, 10:08 PM
John Vinson
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 08:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.