Results 1 to 11 of 11
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Asterisks in field (2003)

    I have put a field on a report, which when run, asks the user for a password. Depending on the password entered, a signature is visible. How can I make this password appear as asterisks when being typed in?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Asterisks in field (2003)

    I assume that the password is a parameter in the query that acts as record source for the report. If not, please explain where the prompt comes from.

    You can create a form with a text box in which the user can enter the password. If you set the Input Mask property of the text box to PASSWORD, all characters entered by the user will be displayed as asterisks.

    Replace the parameter in the query (probably something like [Enter Password]) with a reference to the text box: [Forms]![frmPassword]![txtPassword] where frmPassword is the name of the form and txtPassword is the name of the text box.

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Asterisks in field (2003)

    No. All I've used is a Unbound field to prompt for a password, which seems to work. I'm not concerned about saving the password.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Asterisks in field (2003)

    I don't understand - you can't type anything into a report. Anyway, setting the Input Mask property of the unbound text box to PASSWORD should do what you want.

  5. #5
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Asterisks in field (2003)

    The password makes a graphics field on the report visible. It worked, but now I'm getting an error. I don't really want to type in the password on the form. I need the user to be able to print the form without typing a password in, just that the graphic won't appear.

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Asterisks in field (2003)

    Are you talking about a form or a report? You jump between the two.
    Regards
    John



  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Asterisks in field (2003)

    You will have to explain clearly and in detail what you are doing and how.

  8. #8
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Asterisks in field (2003)

    I have a graphic on a report, which is a signature. I want this signature to be invisible when the report is run, unless an entered password is correct. I've got a text box on the report which prompts for a password. As I said, I don't need to keep the password

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Asterisks in field (2003)

    But how does the password in the text box interact with the graphic? And what is the control source of the password?

  10. #10
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Asterisks in field (2003)

    I have the following code attatched to the report

    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If Me.Text182 = "066" Then
    Me.Image174.Visible = True
    Else
    Me.Image174.Visible = False
    End If

    End Sub

    I've just discovered, it only stops working when there is no data (ie the user tries to print a report for a Works Order that there is no information for), so it may not be a problem after all

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Asterisks in field (2003)

    If you still want the password to be displayed as asterisks while being typed, you will have to do that on a form. The text will always be readable in a normal parameter prompt.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •