Hi All,

I hope someone can help me with this. I believe it can be done but don't know how.

I have a DB with field text properties set to:

Left Justified

Plain Text

Arial 10

I have a script that creates a record and then inserts text into the field described above. I would then like to change the formating of that record only to:

Right Justified

Bold

Arial 12

I believe this can be done in the specify text calculation but I do not know how to write the code to set the format properties. I am willing to look it up myself but do not know where to find the resource to give me the proper tags.

The script then imports a found set of records and sorts basaed on a record number field. This will give the effect of having a bold off set header to a set of data.

I need to do it this way (I think) becauase I need to import and then set in order records from several related tables. Each sub section will need to have one of these headers. A sub summary will not do what I need it to.

I already have all of the other scripting steps working, it is just this formatting issue I would like to figure out.

Any help would be greatly appreciated.

Thanks,

Steve

PS I thought conditional formatting would get me there...it almost does...but not quite because of the opaqueness of the test. If I take "x" number of fields and stack them (conditioned to white text)when the condition is met and lettering changes to black the white skeletons letters behind the conditioned text show through. If there is a way to condition to transparent I am all ears (or eyes I guess!)

Generally it's best not to format the actual data in the fields; instead format the field objects themselves, or use multiple merge codes in a text block and format these as required.

Text formatting cannot be exported, so it's not a good idea to "encode" data through formatting.

Some time ago somebody posted a question where IIRC they had a string of text and had formatted some characters with symbol font to display greek letters. They then had to export the data out and found the formatting got lost... and most of the meaning was lost.

Hey Vaugh,

Thanks for the reply But this part went over my head

or use multiple merge codes in a text block and format these as required.

Can you elaborate a little so I know where to look?

I thought I was formatating the object. Actually I have tried both...I am so darn close...If I could condition to transparent letters I would have it!

Thanks,

Steve

I figured out a solution with some creative use of conditional formatting! It required a second field but works just as well and is all back end so the user will never see.

This program never ceases to amaze me.

Steve