Max of text boxes (1 Viewer)

[KevlarKev]

Hi everyone,

Does anyone know how I can get the max of 5 textboxes I have on a form?

The textboxes are bound.

For e.g. I have 5 textboxes (just call them text1 - 5) and each has a date in it. I want another textbox (unbound) to calculate the maximum date of the other 5.

Is this possible?

I currently have =max([text1],[text2],[text3],[text4],[text5])

Help!

 

[pbaldy]

How about:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209857