Results 1 to 2 of 2
  1. #1
    shod90 is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Posts
    134

    Change particular record background on continuous form

    Dear Gents,


    I wrote a code snippet that loops through all records on an continuous form, This loop checks if the CurrentStock less than MinStock then change background of this particular product which match the if condition , But unfortunately it changes all backgrounds for all products.

    Code:
    With Me.Recordset  .MoveFirst
      Do While Not .EOF
        If CurrentStock < MinStock Then
          Prd_Code.BackColor = vbRed
          Prd_CurrentStock.BackColor = vbRed
        Else
        End If
        .MoveNext
      Loop
    End With
    Any help please ?

  2. #2
    shod90 is offline Competent Performer
    Windows 8 Access 2016
    Join Date
    Jan 2016
    Posts
    134
    Solved by conditional formatting .. But i'd like to know if it can be solved through code or no .

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

Similar Threads

  1. Change Form Background Colour
    By Emma35 in forum Forms
    Replies: 11
    Last Post: 01-25-2016, 06:12 AM
  2. Replies: 8
    Last Post: 11-28-2015, 12:00 PM
  3. Replies: 4
    Last Post: 08-29-2015, 07:38 AM
  4. Replies: 4
    Last Post: 10-28-2014, 09:51 AM
  5. 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