Examples of where .Value is required?

[Micron]

This probably could go in a few forums but I just picked this general one. For quite some time I've wondered just how many places .Value is required in Access. Now that I've got a few in mind I thought I'd see if anyone can add to the list. Here's what I've come up with (some using the immediate window):



1)
If you want to know the data type that a form control contains:
?typename(forms!form3.[lastname].Value)
String

Otherwise, the control type will be returned:
?typename(forms!form3.[lastname])
TextBox

2)
If you drill down to a form control and test/set a bunch of properties but also want to know what it contains (not its Text property):

With Me.myControl
  .Backcolor = vbYellow
  .ForeColor = vbBlack
  .Value = "Test"
End With

I suppose for #2 there might be a way around it, but the above would seem the most efficient and practical to me.

3)
If you need to apply query criteria to a multi value field. Since you usually would not know the mvf record index number:
WHERE mvf_Names.Value = "Sam"

I thought it would be required to get the value of a property but it doesn't seem to be.
Can anyone add to the list for Access?

[ranman256]

You don’t need .value. It’s understood.
ive seen it cause more problems than not. So don’t use it.

[Micron]

Well, you're wrong about that but thanks anyway.

[davegri]

Establishing/defining tempvars

TempVars!tvTargetYear = Me.cboYear.Value

You get an error if value is omitted as Access thinks you want to set the tempvar to the combo box object which is not allowed.

[Micron]

Thanks Davegri. I was holding off replying to see if I got any more examples but I guess that's going to be it.

[Micron]

As per cj_london, .Value would be required to get the lookup value from a lookup field. I knew that was the case in queries as per #3 above, but I suppose the need can be extended to retrieving the value in a control that is being displayed from a lookup field. At least I presume he was referring to a control:
https://www.accessforums.net/showthr...t=86171&page=2