Results 1 to 4 of 4
  1. #1
    fishhead is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    167

    user guidance message

    Is there a way to have a short message in a field (if that field is blank) to guide the user on how to update that field



    for example I have [vendor ref] field that i would like the users to update but in a specific format (alfa-numeric)
    is there a way to have this field show (alfa-numeric) in brackets and perhaps in a lighter font (similar to some date fields that show (dd/mm/yy) in the field before the user updates it?

    thanks,
    Steve

  2. #2
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,654
    In the format field of the property sheet put
    Code:
     @;"your text"
    Click image for larger version. 

Name:	fmat.png 
Views:	14 
Size:	5.6 KB 
ID:	42805

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    you can also add a limited range of colours

    @;[red]"your text"

    with regards fonts etc use conditional formatting where the condition is isnull(controlname)

  4. #4
    fishhead is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    167
    Quote Originally Posted by Ajax View Post
    you can also add a limited range of colours

    @;[red]"your text"

    with regards fonts etc use conditional formatting where the condition is isnull(controlname)

    works well, thanks guys!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 05-13-2018, 12:59 AM
  2. Replies: 2
    Last Post: 01-04-2017, 06:05 PM
  3. Nagging Multiuser Access Message for a single user
    By Jerry O in forum Programming
    Replies: 3
    Last Post: 02-18-2015, 10:15 AM
  4. Message Box and User Input
    By MintChipMadness in forum Programming
    Replies: 3
    Last Post: 01-10-2013, 05:18 PM
  5. Send a message for other user
    By smahdih in forum Access
    Replies: 2
    Last Post: 11-18-2011, 01:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums