Hi @mresann
Number format into 1st 2nd 3rd etc. I have hidden control on form bound with table, which keeps increasing by DMAX, while the data is entered by user.
I found your post on the link below. My question is where and how to use this code. thanks.
Number format into 1st 2nd 3rd etc. I have hidden control on form bound with table, which keeps increasing by DMAX, while the data is entered by user.
I found your post on the link below. My question is where and how to use this code. thanks.
number to ordinal list (1st, 2nd, 3rd...)
Hi All, Here's a quick and nasty function to convert a number to it's ordinal representation. e.g. 1 = 1st 2 = 2nd 3 = 3rd etc. Public Function IntToOrdinalString(MyNumber As Integer) As String Dim sOutput As String Dim iUnit As Integer iUnit = MyNumber Mod 10...
www.access-programmers.co.uk
