Updating a label with a series of messages

[brianjessup]

How would you update a single label with a series of text messages based on an index? For example, let's say you want your label to display the days of the week. So when an index = 1, the label would read "Monday", etc.

My start is:
Const Daylabel1 As String = "Monday"
Const Daylabel2 as String = "Tuesday"

Etc....

Then calling it like


MyLabel.caption = ???? ("Daylabel" & index) ????

if index = 1 then it should read "Monday"

THANKS!

 

[dcx693]

Try using the Access Choose() function.

 

[charityg]

MyLabel.caption = Format(index+1,"dddd")