Hello:

I have a form that displays in table view that lists job orders. If someone changes the quantity of a job, I want to change the font color of the quantity to red to indicate a change. Is this possible in table view? I change font using TextColor()on a field in Form view but cant get it in table view.

Thanks!

Rick

Is this done via a autoenter or a scripted change, if it's autoenter how do you set all fields uncoloured when a record is opened?

--sd

Scripted change

Then set your field to it self (and/or the new value) to:

TextColor ( test::field1 ; RGB ( 255 ; 0 ; 0 ) )

Ideed it will show correctly in table view as well!

--sd

OK, i can get it to work on text fields, but not on numeric fields....it does change the font color when editing the field but when you click out of the field the font goes back to black.

Hi Rick,

This means that you have changed the formatting at the field level only on the field in the table layout.

Select Format > Number and change it back to General Format.

LaRetta

Hi LaRetta... Are you sure that it's not because numeric fields don't display non-numeric information -- i.e. text / colouring etc.

Hi Genx,

Uh, no.

Number fields can display text. Number fields can also handle other text formatting such as:

Right ( "000" & Table::Quantity; 3 )

But number fields can NOT handle text colorizing if number format has been applied.

kk, interesting. Well it seems they won't actually show text if number formatting has been applied either..

Edited June 21, 200718 yr by Guest

Right, I wasn't as concise as I should have been. No, numbers don't DISPLAY text but you can preface them with zeros. But text formatting can be applied to numbers - but NOT colorizing when field-level formatting has been applied to the number. There are many posts on the issue - it goes back for 3-4 years now.

Edited June 21, 200718 yr by Guest

Lol.. yeh just noticed that, turns out i was testing your theory on a text field that i happen to use to store a single digit number ;)

That's okay - we make a pair ... I was too scattered and shouldn't have been posting anyway.

Let me try again:

Colorizing numbers does NOT work when field-level formatting is applied. It hasn't worked since vs. 7 and still does not work. For the first time, in vs. 8, we can now colorize numbers! But still NOT when field-level format is applied. We have ALWAYS been able to apply text formatting functions to number fields. Whew!

Concise? I've been learning from Comment. :wink2:

There's a version difference regarding using TextColor() on a Number field.

In version 7, if the field has a Decimal or Boolean format applied to it, it will ignore the color.

In version 8.5, color will be applied in all number formats.

EDIT: What's field level formatting?

Edited June 21, 200718 yr by Guest

EDIT: What's field level formatting?

Formatting applied at the layout level (which is display only) and not actually changing the data, ie, it displays as wished but entering the field produces the unformatted data. Of course you know this so I'm feeling funny answering you; wondering what will follow. Genx, help!

Maybe I should call it layout-level formatting? I mean through Format Field, ie, field-level. Am I digging this trench deeper with each word?

LaRetta <--- slinking off ROFLMAO!

Lol, I'd love too, but i already take my fair share from comment

I've learnt that at some point it's better to cut your losses and say "Michael your right, I slipped up" and just leave it there lol.

Ah, but if he asks a question? I can't cut and run - I answer! Wouldn't you? Yep, 'cus you're like me - you enjoy it too darned much for your own good.

Well, let's see how I :titanic:

Lol i did say at SOME point didn't I ;)

Of course you know this

No, really, I don't - and I will try to forget it as quickly as I can. Because it doesn't make sense (to me) and it's misleading. The formatting is applied to a specific field instance on a specific layout. You could place another instance of the same field on the same layout and format it in a completely different way - so how can it be at field or layout level?

---

I think FM Help calls it "formatting field objects".

Lol there you go:

Field Object Level Formatting

Actually that is a surprisingly good term for it

But if a field is an object in layout mode it's

Layout Object Level Formatting.

Now I'm confused...LOL

Well think of it this way, a field-object is an occurrence of a field on a layout not the field within the table.

You could more broadly refer to formatting things on layouts as object level formatting.

lol like I said ;)

Well yes, but the point i was trying to get across is that the "Layout" part wouldn't be necessary.

Alex <--- suck up

Michael,

Ah. Then I should go with what FM calls it. But I meant 'field level' as a specifc instance of the field - not globally per layout nor field data but ONE layout INSTANCE of the field. Field-level does indeed sound like it should change the data and field-object level eliminates that error.

Even small (very small) things matter ... at some time, somewhere, to someone, in some part of the world, who might once in a lifetime misinterpret my meaning. So yes, I will change my wording in future and call it field-object level formatting as well.

LaRetta <--- contrary-for-no-darned-reason-other-than-she-wants-to-be-right-now :bigshades:

I think we'd all be better off if we called everything what FM calls it.....lol

ROFLMAO

I need to score suck up points so his tellings off are less painful later ;)

Fat chance.

Every thing's worth trying once ;)

It seems some types of text formatting are working with a number field that has colored data showing. What specific things are you trying to do? As comment mentioned, this area has been improved.

Here's an example file with an auto-enter to change negatives to red, and field object level formatting on some instances of the field, which maintain the redness.

colorNum.fp7.zip

Rick shows he's on vs. 7 which was why I responded; and I had tested it on vs. 7 again to be sure. I still have vs. 8.0 on my Dell and my Mac (which has vs. 8.5) is still in a shipping box.

I had gotten confused whether it changed in vs. 8.0 or 8.5 and what specifically changed. Thanks for clarifying for us!

Is the same true for date fields??