Negative & Positive

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help Needed

How can i negative values to appear in red color and positive value in blue
color.
 
Put the following code in the Current of your form:
Select Case Me!NameOfTextBox
Case > 0
Me!NameOfTextBox.background = vbBlue
Case < 0
Me!NameOfTextBox.background = vbRed
Case Else
Me!NameOfTextBox.background = vbWhite
End Select
 
Is this in a form and if so, is it continuous or single record? Or, are you
asking about a report? You can't do this in a table's datasheet view.

PC Datasheet's response will only work if the form is in single record view.
You might want to search help on Format Property for numeric values.
 
Thx PC Datasheet, your reply was great help.

PC Datasheet said:
Put the following code in the Current of your form:
Select Case Me!NameOfTextBox
Case > 0
Me!NameOfTextBox.background = vbBlue
Case < 0
Me!NameOfTextBox.background = vbRed
Case Else
Me!NameOfTextBox.background = vbWhite
End Select

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
Reverse color numeric formatting? 2
Fonts Color 3
Reallocate array cells value from positive to negative 0
Different Color for Negative and Positive Value 4
Chart in Excel 2007- Positive & negative value columns 10
Excel VBA to match positive and negative transactions 3
Two-tone color column chart 2

Back
Top