I am wanting to create a list of letters of the alphabet, which when clicked upon will execute a script (that will return records beginning with that specific letter) and then highlight that letter in the list.

I can envisage 26 buttons each calling the same script passing in the chosen letter. Where I am struggling is with how to highlight the letter somewhere in this process.

I have spent hours barking up lots of wrong trees!!

Can anyone help me please.

Many thanks

Tim

Edited October 18, 200817 yr by Guest

You need to store the chosen letter in a global (field or variable), so that each letter in the list can compare itself to it. A repeating calculation field would be convenient here, e.g.

Let ( 

char = Middle ( "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ; Get ( CalculationRepetitionNumber ) ; 1 ) 

;

Case ( char = Extend ( gChar ) ; TextColor ( char ; 255 ) ; char )

)

Cool! Thanks for pointing me in the right direction again comment.

I first tried setting up the repeating 26 field as a text field with the code on auto-enter but that wasn't working. Then I realised you'd said a "calculation" field. Now she's sorted.

Thanks again.