Combining text fields

  • Thread starter Thread starter Jaime
  • Start date Start date
J

Jaime

Hi There!

I am using a text box to combine several text fields.
Around them I want to put a Parathenesis. Is this possible.
 
Thanks,

How do I prevent the () showing if there is no value in
the text box for a record?

Thanks
-----Original Message-----
Jaime,
="(" & [Field1] & " " & [Field2] & ")"

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Jaime said:
Hi There!

I am using a text box to combine several text fields.
Around them I want to put a Parathenesis. Is this possible.
Click to expand...


.
Click to expand...
 
="(" + [Field1] + " " + [Field2] + ")"


--
Duane Hookom
MS Access MVP


Jaime said:
Thanks,

How do I prevent the () showing if there is no value in
the text box for a record?

Thanks
-----Original Message-----
Jaime,
="(" & [Field1] & " " & [Field2] & ")"

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Jaime said:
Hi There!

I am using a text box to combine several text fields.
Around them I want to put a Parathenesis. Is this possible.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top