Vb Formatting

[FREDDY67]

Evening

I am formatting the bank holidays in a calendar & I came accross the alignment format, but I don't know & can't find the required value for any position. Any help would be greatly appreciated;

If (intPubMyYear = 2009) Then
If (intPubMonth = 1) Then
If (intDay = 1) Then
Me("Day" & Trim(r)).BackColor = "6710886"
Me("Day" & Trim(r)).FontBold = True
Me("Day" & Trim(r)).ForeColor = "15921906"
Me("Day" & Trim(r)).Alignment = ??????

My Apologies, I was using the wrong format control, the correct format is text align, as follows;

Me("Day" & Trim(r)).TextAlign =

General 0 (Default) The text aligns to the left; numbers and dates align to the right.
Left 1 The text, numbers, and dates align to the left.
Center 2 The text, numbers, and dates are centered.
Right 3 The text, numbers, and dates align to the right.
Distribute 4 The text, numbers, and dates are evenly distributed.


Many Thanks

Freddy

 

[DCrake]

What kind of calendar control are you using and does it support the text alignment option? Also what version of Access are you using?