In Access how can i refer to the value of the text box by day of .

[Guest]

In access i have a text box that has the day of the week based on the date,
however when i try to write an IF statement making the condition Monday for
example the If Statement does not work even when i put .value in the
IfStaement so how can i refer to the value of the day in the text box?

Any help would be appreciated

 

[Barry-Jon]

Referring to the textbox from the form on which the text box is
present.

if Me.txtDay.value="Monday"

end if

 

[Van T. Dinh]

It depends ... You may have a Date value and simply use the Format Property
to display the day of the week. In this case, you If condition needs to use
expression (e.g. Format() function, etc ...) to convert from the Date value
to the day of the week.

Post the ControlSource and its data type of the TextBox and your attempt(s)
of the If statement.