Multiple Format types in one Details View

[jonefer]

I'd like to write a select statment to set different format types
depending on a value in another field


for example
dim DisplayString as string


Select Case [Measure]

Case 'Panel'
DisplayFormatString = '{0,whole integer} 'not sure of the proper syntax

Case 'AveAge'
DisplayFormatString = '{0, percentage}

Case 'StartDate'
DisplayFormatString = '{0, mmm-yyyy}'

end select

is this possible? - Do I use the sort expression ?