Change the field content when printing

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

Guest

I would like to change the field content before to print the detail part of
my print out.
I have two fields. The first one must be complete with the content of the
second one when printing (or previewing).
Example:

Field1 = "I have a good <Param1> !"
Field2 = "idea"
The result expected is: "I have a good idea!" <Param1> must be replace by
the filed2 content.

Many thanks in advance.

NB
 
Nicobou said:
I would like to change the field content before to print the detail part of
my print out.
I have two fields. The first one must be complete with the content of the
second one when printing (or previewing).
Example:

Field1 = "I have a good <Param1> !"
Field2 = "idea"
The result expected is: "I have a good idea!" <Param1> must be replace by
the filed2 content.
Click to expand...

=Replace(field1, "<Param1>", Field2)
 
Sorry but I don't find the function Replace() in the expression builder.
Where do I have to look for?
 
What version of Access are you using?

Replace didn't exist in A97 and before, in A2K it was there,
but unavailable through the expression servce (SQL and
control expressions) and should be fully available in AXP
and later.
 
Thanks a lot.
I wrote a VB function to call the function Replace().
But I have still a problem when the original string doesn't content the
searched substring I have an error generated and can't trap it before the
printing.
I was looking for a substring search function ... ? I am not a VB expert :-)
Any idea?

Nicolas
 
Nicobou said:
I wrote a VB function to call the function Replace().
But I have still a problem when the original string doesn't content the
searched substring I have an error generated and can't trap it before the
printing.
I was looking for a substring search function ... ? I am not a VB expert :-)
Click to expand...


What version of Access are you using?

Can't tell what's wrong with your code unless I can see the
code. Please post a Copy/Paste of your procedure.
 
It is working now. The error was that the replace() function doesn't accept
an empty field (null or blank value) in the pRelacement string and I had some
"null or blank" values in the <Param1> field.
I replaced the null value in my table field with a not null string and then
that worked.
Do you have another idea to fix this problem.
NB
 
Nicobou said:
It is working now. The error was that the replace() function doesn't accept
an empty field (null or blank value) in the pRelacement string and I had some
"null or blank" values in the <Param1> field.
I replaced the null value in my table field with a not null string and then
that worked.
Do you have another idea to fix this problem.
Click to expand...


If you want to replace a substring with nothing, then the
replacement string needs to be a string with no characters.
This is known as a ZLS (Zero Length String) and, in VBA, is
written as "".

You can get a ZLS in a table without user intervention by
setting the field's properties to:

Allow Zero Length Yes
Required Yes
Default Value ""
 
Thanks a lot for your help. Nic.

Marshall Barton said:
If you want to replace a substring with nothing, then the
replacement string needs to be a string with no characters.
This is known as a ZLS (Zero Length String) and, in VBA, is
written as "".

You can get a ZLS in a table without user intervention by
setting the field's properties to:

Allow Zero Length Yes
Required Yes
Default Value ""
Click to expand...
 
Back
Top