Format date as day of week starting on a Monday on a form

[nwtools]

The week at our manufacturing plant starts on Monday. To format a date as the number of the day of the week you enter a w in the format box on the property sheet. However that starts the week on Sunday. I know 2 is the number to start the week on Monday but I cannot get the nomenclature correct. w2 does not work, neither does w,2, nor w[2]. Does anybody know what the correct format is? Thanks

 

[dhookom]

You can add another argument like:

? Format(Date(),"w",vbMonday)

You can also replace vbMonday with 2 outside of vba.

Duane
Hook'D on Access
MS Access MVP