Results 1 to 2 of 2
  1. #1
    mujaqo is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2008
    Posts
    13

    Question A code to change textbox property in a form?

    Hi, I'm new to Access and I need a little help on how to change a textbox properties in a form, I have seven textboxes named Sat,Sun,Mon... and I wrote the below code to find the current day:
    Dim Today As String
    Today = Format(Date, "ddd")
    What I’m looking for is a code to change the textbox BackColor for the textbox that matches the value returned by the above code.


    Thanks,
    Mujaqo

  2. #2
    Join Date
    Jul 2008
    Location
    Alexandria, Egypt.
    Posts
    38
    Dear mujago,

    You can use conditional format ... right click on the textbox and choose conditional format.

    Thanks

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

Similar Threads

  1. total in textbox
    By micfly in forum Access
    Replies: 3
    Last Post: 11-09-2008, 11:24 AM
  2. Textbox will not allow input
    By cwf in forum Forms
    Replies: 0
    Last Post: 04-04-2008, 04:08 PM
  3. 'On Open' Property
    By emilylu3 in forum Forms
    Replies: 1
    Last Post: 12-08-2005, 02:28 PM
  4. Change the colour of a form background
    By r_e_v_a_n_s in forum Forms
    Replies: 0
    Last Post: 11-15-2005, 03:39 AM

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