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

C

College Kid

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
 
B

Barry-Jon

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

if Me.txtDay.value="Monday"

end if
 
V

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.
 
Top