Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to change field format
Message
From
09/05/2007 09:28:19
Reza Meamar
Homa Programming Group
Shiraz, Iran
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP1
Miscellaneous
Thread ID:
01223683
Message ID:
01223731
Views:
14
>>Dear all
>>i want to know how to change field format ( in detail band ) based on a variable value.
>>for example i want if FldFmt = 1 so my field format be @J 999999.999 and if FldFmt = 2 so @J 999999.9
>>Thanks for your help
>
>Instead of defining the field as numeric, define it as character. In the expression enter something like this:
>
>TransForm(MyData, IIF(FldFmt = 1, '@J 999999.999', IIF(FldFmt = 2, 'asldkfjalsdfj', 'alsdkfjas')

YES, It work.
THANK YOU VERY MUCH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform