Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6960 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I'm using TextColor to Hilite some words in lines.

The problem is it shows them with a space-like distance from their position.

In the first example i'm replace "ebook" and in the second "is".

as you can see it doesn't look good.

I tried to change fonts and I have the latest update (FMD 7.03).

Any suggestions to what may cause this problem?

untitled.JPG

Posted (edited)

Substitute ( text ; searchString ; TextColor ( text1 ; RGB ( red ; green ; blue ) ) )

Edited by Guest
Posted (edited)

You might wish to use a global field in which Users can insert the text they wish to highlight, maybe called gText. Also, you used comma and vs. 7 requires semi-colon. Try this:

Substitute ( line ; gText ; TextColor ( gText ; RGB ( 255; 0; 0 ) ) )

UPDATE: XTRIM, you changed your calc. Regardless, the above works.

LaRetta :wink2:

Edited by Guest
Added update
Posted

Your example is working just fine...so maybe my file is corrupt or maybe it's a load issue (500,000 records....)?

Posted

Corruption maybe but I doubt it. Are you sure you don't have a space as in " is" ??

Have you tried it using a global field? Can you attach your file? Your example line looks wonky to me. Are those separate sentences concatenated? Maybe you have a space in there somewhere because it surely works.

Posted

Can you post a copy of the file so that we may check it to see if we can replicate the problem as well?

Posted (edited)

XTrim I have replicated your problem in your file.

The problem seem to be with the data in the main text field itself (line). The calculation is fine. If I create a new record and TYPW the exact same data in the new field it formats it correctly.

Where did this data come from? Did you copy and paste it? Was it imported?

However it may have been populated; know that it is is NOT the calculation. It is the data.

screenshot.gif

Edited by Guest
Added screenshot
Posted

The data is imported from a text file with the troi file plugin...

I leave the data unformatted because it is required.

But still it is strange because in the line itself there are no problems, only when you color it...and how come on some computers it is working fine? strange.

I'll look into it again...

tnx everyone

This topic is 6960 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.