Results 1 to 5 of 5
  1. #1
    baka77 is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2012
    Posts
    2

    Question Where is the code

    I have an Access file with query, forms, tables which I did not create and I am trying to understand how it works.



    In one of the form, I have some combo boxes and some text boxes.
    The combo boxes contains three values 0, 1 , 2
    Depending on the value selected in the combo box, the text color in the text box change .
    I am looking for the code doing this.

    I have checked the combo box event via the design mode but all the events are empty.
    I also checked via Visual Basic editor but it is almost empty, there was no function which change the text box color.

    Unfortunately I cannot attach any files, if you have any clue please post an answer.

    Thank you very much in advance.

  2. #2
    R_Badger is offline Knows a few tricks
    Windows XP Access 2003
    Join Date
    Feb 2012
    Location
    Suffolk, UK
    Posts
    262
    That sounds like conditional formatting

    Also if you want to understand how it works I suggest reading:

    For normalisation http://www.barrywise.com/2008/01/dat...gn-techniques/

    For SQL http://www.w3schools.com/sql/default.asp

    Knowing those two things should help you understand how the data works, but the above should solve your more immediate issue.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    And for conditional formatting review http://office.microsoft.com/en-us/ac...010208133.aspx
    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.

  4. #4
    R_Badger is offline Knows a few tricks
    Windows XP Access 2003
    Join Date
    Feb 2012
    Location
    Suffolk, UK
    Posts
    262
    Thanks June, typical me lately! links to everything bar what the question was actually about! (and to add to it I posted this against the wrong thread a minute ago, that'll teach me to have this open on two computers at once!

  5. #5
    baka77 is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2012
    Posts
    2
    Thank you very much, you are right.
    It was conditional formatting, I did not know about this feature in Access.
    It was a real mystery until now

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

Similar Threads

  1. while code
    By tmcrouse in forum Programming
    Replies: 1
    Last Post: 09-26-2011, 12:57 PM
  2. Word code in Access - How to modify my current code
    By Alexandre Cote in forum Programming
    Replies: 0
    Last Post: 11-15-2010, 08:26 AM
  3. Code in combobox, code in text box
    By float in forum Forms
    Replies: 3
    Last Post: 09-29-2010, 07:12 AM
  4. Access 2003 code vs Access 2007 Code
    By ralphjramirez in forum Access
    Replies: 5
    Last Post: 11-23-2009, 12:33 PM
  5. Help with VBA Code
    By access.newby in forum Forms
    Replies: 1
    Last Post: 11-15-2009, 05:43 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