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