Using Field ID to access the data in the field.

[wricoasolutions]

I am new to Access, I know how to access the data within a field by using the field name as a variable. (Variable1 = (value(fieldname1)) or syntax similar to this. My question is, is this type of function available in Access and if so where is it in the text/manual. Or, could someone give me an example of this function.

Thank everyone for any help on this.

Bill

 

[RuralGuy]

If you are trying to convert a string to a numerical value then you may want Val(). You can searsh for Conversion or Conversion Functions in the VBA help. Go view a code page first and press F1.

 

[wricoasolutions]

Understand what is happening, will give it a shot, should get me where I need to go.

Thanks.

 

[WayneRyan]

Bill,

If you want to refer to a control programmatically:

Dim SomeFieldName As String
Dim SomeContent As String

SomeFieldName = "txtLastName"

SomeContent = Me.Controls(SomeFieldName)

Or in a loop:

Dim i As Long
For i = 1 to 9
   ' do something with --> Me.Controls("Field" & CStr(i))
   Next i

Wayne

 

[wricoasolutions]

Wayne,

Thanks for the additional information. Will give it a try. Looks like the type of functionality that I am used to.

Bill