Thread: concatenate
View Single Post
  #4  
Old September 7th 06, 11:31 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default concatenate

Still looking for details. What is test supposed to be -- a static text string? Total is a currency field?

End result would be test$1.00.


Only if the initial value for Total is $1.00.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Joel Allen" wrote in message ...
Yes Sue, it is a custom field in a custom form. Within the properites, I
want to set the intial value of the field to test + [Total], where Total is
another custom field. End result would be test$1.00.

Thanks,
Joel


"Sue Mosher [MVP-Outlook]" wrote in message
...
Details please: This is for a formula on a custom form? Total is the exact
name of a field on that form?

Start by putting a space between & and the field name.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Joel Allen" wrote in message
...
Hello,

I'm trying to concatenate some text with a field in the properites of the
fields and it's not working. Any help on syntax?

"text "&[Total]

Thanks
Joel




Ads