Formatting Text on character & memo fields

#1

Hello,

I am using VFP 6.0 - service pack 5.

I am looking for a way to format specific text that has been stored in or
will be stored in character or memo fields.

For Example;
I want to store "This is a line of text in which <this> word is in bold and
<this> word is underlined" into a character or memo field in my database.

I would then like to take the text from the database field and print it out
using a report, with the appropriate text in bold or underlined etc.

Any ideas?

Thanks in advance
Mark Nixon

#2

Not going to be easy. My only suggestion would be to use Word for your report
writer instead, automate that and bold your words.
Hm. or you could TRY (and I do mean try; as I don't hink i twould work) is use
the richtext control in the report ...

On Tue, 16 May 2006 14:09:11 +0930, "Jack Jones" <ajack100nospam (AT) hotmail (DOT) com>
wrote:

Quote:

Hello,

I am using VFP 6.0 - service pack 5.

I am looking for a way to format specific text that has been stored in or
will be stored in character or memo fields.

For Example;
I want to store "This is a line of text in which <this> word is in bold and
this> word is underlined" into a character or memo field in my database.

I would then like to take the text from the database field and print it out
using a report, with the appropriate text in bold or underlined etc.

Any ideas?

Thanks in advance
Mark Nixon

--- AntiSpam/harvest ---
Remove X's to send email to me.

#3

One way would be to use the Microsoft RTF control. You place this on a form
and bind it to a memo field, then formatted RTF text can be stored in the
memo field. In order for this to work on reports, you would need a report
tool that can interpret RTF, such as Crystal reports.
hth
wayne
"Jack Jones" <ajack100nospam (AT) hotmail (DOT) com> wrote

Quote:

Hello,

I am using VFP 6.0 - service pack 5.

I am looking for a way to format specific text that has been stored in or
will be stored in character or memo fields.

For Example;
I want to store "This is a line of text in which <this> word is in bold
and <this> word is underlined" into a character or memo field in my
database.

I would then like to take the text from the database field and print it
out using a report, with the appropriate text in bold or underlined etc.

Any ideas?

Thanks in advance
Mark Nixon

#4

Thanks for your replies, Wayne & Josh

I will look into the RTF option. I have not come across Crystal reports
before (I am only a very much part-time programmer) Would you (or anybody
else) reccommend it over and above the report generator that comes with
VFP6?

It has always seemed to me that the standard report generator is somewhat
"clunky" to use and rather limited and I would like to investigate other
report writers if they offer better features and integrate easily with VFP6

Any further comments would be greatly appreciated.

Mark (Jack)

"wayne dooley" <spammers (AT) must (DOT) die> wrote

Quote:

One way would be to use the Microsoft RTF control. You place this on a
form and bind it to a memo field, then formatted RTF text can be stored in
the memo field. In order for this to work on reports, you would need a
report tool that can interpret RTF, such as Crystal reports.
hth
wayne
"Jack Jones" <ajack100nospam (AT) hotmail (DOT) com> wrote in message
news:126ilrf7nmvor88 (AT) corp (DOT) supernews.com...
Hello,

I am using VFP 6.0 - service pack 5.

I am looking for a way to format specific text that has been stored in or
will be stored in character or memo fields.

For Example;
I want to store "This is a line of text in which <this> word is in bold
and <this> word is underlined" into a character or memo field in my
database.

I would then like to take the text from the database field and print it
out using a report, with the appropriate text in bold or underlined etc.

Any ideas?

Thanks in advance
Mark Nixon

#5

I only recommend crystal reports if you need it. and I mean NEED it.

It's expensive, not intuitive & something "extra" to futz with.

If you set your mind to it; you can do some gcool stuff with the vfp writer and
aftermarket stuff (like frxtoany etc)

On Thu, 18 May 2006 09:47:17 +0930, "Jack Jones" <ajack100nospam (AT) hotmail (DOT) com>
wrote:

Quote:

Thanks for your replies, Wayne & Josh

I will look into the RTF option. I have not come across Crystal reports
before (I am only a very much part-time programmer) Would you (or anybody
else) reccommend it over and above the report generator that comes with
VFP6?

It has always seemed to me that the standard report generator is somewhat
"clunky" to use and rather limited and I would like to investigate other
report writers if they offer better features and integrate easily with VFP6

Any further comments would be greatly appreciated.

Mark (Jack)

"wayne dooley" <spammers (AT) must (DOT) die> wrote in message
news:8N-dnUXnx48dDffZnZ2dneKdnZydnZ2d (AT) comcast (DOT) com...
One way would be to use the Microsoft RTF control. You place this on a
form and bind it to a memo field, then formatted RTF text can be stored in
the memo field. In order for this to work on reports, you would need a
report tool that can interpret RTF, such as Crystal reports.
hth
wayne
"Jack Jones" <ajack100nospam (AT) hotmail (DOT) com> wrote in message
news:126ilrf7nmvor88 (AT) corp (DOT) supernews.com...
Hello,

I am using VFP 6.0 - service pack 5.

I am looking for a way to format specific text that has been stored in or
will be stored in character or memo fields.

For Example;
I want to store "This is a line of text in which <this> word is in bold
and <this> word is underlined" into a character or memo field in my
database.

I would then like to take the text from the database field and print it
out using a report, with the appropriate text in bold or underlined etc.

Any ideas?

Thanks in advance
Mark Nixon

--- AntiSpam/harvest ---
Remove X's to send email to me.

#6

There is a Czech tool named XFRX. I think it works with VFP6 (works very
well with VFP9). Look at

www.eqeus.com

--
J. MAURICE @Grenoble.France.Europe UFPRC - Foxil

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Formatting Text on character & memo fields

comp.databases.xbase.fox comp.databases.xbase.fox

Formatting Text on character & memo fields - 05-15-2006 , 11:39 PM

Re: Formatting Text on character & memo fields - 05-16-2006 , 08:21 AM

Re: Formatting Text on character & memo fields - 05-16-2006 , 09:54 PM

Re: Formatting Text on character & memo fields - 05-17-2006 , 07:17 PM

Re: Formatting Text on character & memo fields - 05-17-2006 , 07:37 PM

Re: Formatting Text on character & memo fields - 05-23-2006 , 04:57 AM