Results 1 to 7 of 7
  1. #1
    Jamesiv1 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2014
    Posts
    28

    How to change font color in a form?

    Can't find this for the life of me.

    All I want to do is change the font color and weight of a couple of columns in a form. No conditions or change when button is pressed or anything like that. Just be blue and stay blue.

    I've tried making it a memo, rich-text field and it didn't work.

    It works fine in the "member details" form, but not the "member list" form.

    Member Details:




    Member List:


    Help?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    txtBox.ForeColor = vbRed

  3. #3
    Jamesiv1 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2014
    Posts
    28
    Quote Originally Posted by ranman256 View Post
    txtBox.ForeColor = vbRed
    Thanks ranman256, but I'm a total rookie. Can you tell me where that line goes?

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Sorry...I just had a guy ask.."what is a field?"

    Tho, I thought you wanted to color it during an event.

    But If it's a permanent color in the form ....design the form, dbl-click the textbox to see properties, set FORE COLOR
    or click the FONT COLOR button on the toolbar..see photo.
    Click image for larger version. 

Name:	clip.png 
Views:	14 
Size:	3.9 KB 
ID:	16483

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Did you try setting the ForeColor property of the textbox? That looks like Datasheet View. Apparently, the property is ignored in Datasheet View.

    Can use Continuous View and arrange controls to look like Datasheet.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    Jamesiv1 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2014
    Posts
    28
    thanks June7. In properties I see:

    default view: split form
    split form orientation: datasheet on bottom
    split form printing: datasheet only

    yes... when I switch to continuous forms for default view, it looks fine.

    so you're saying I have to arrange the controls to look like a datasheet? I just tried it with one field, and it only showed the 1st record, not all of them...?

  7. #7
    Jamesiv1 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2014
    Posts
    28
    meh... no big deal. I can live with it. I figure the users will open up the member card most of the time, anyway - it looks fine on the member card.

    thanks guys!

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

Similar Threads

  1. Change font color in Query
    By Brian62 in forum Queries
    Replies: 2
    Last Post: 01-10-2013, 09:14 PM
  2. Change font color in subform
    By rtrinidad in forum Forms
    Replies: 1
    Last Post: 11-04-2012, 01:42 PM
  3. Change color font when updating data?
    By Mike1379 in forum Reports
    Replies: 3
    Last Post: 05-17-2010, 08:00 AM
  4. Change as per condition font color
    By miziri in forum Programming
    Replies: 1
    Last Post: 08-20-2009, 04:23 AM
  5. Color/font change in subform
    By AndyKim in forum Forms
    Replies: 9
    Last Post: 06-24-2009, 04:34 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