Grouping Objects into one name

[stu_c]

Hi all
I have got 30 odd fields that I need to code is there anyway to group these together under one name, for example

FIELD NAMES
Field1
Field2
Field3
Field4
etc

Group Name
FormFields

I now there is a way but I cannot for the life of me remember how to

 

[arnelgp]

in a query you can:

select (field1 & field2 & field3 & …) As GroupName from table.

in form, you can Group the controls in the Ribbon->Arrange->Size/Space->Group.

 

[stu_c]

Hello
thank you for the replay, can you not do this in VBA on the form as I was almost certain you could?

in a query you can:

select (field1 & field2 & field3 & …) As GroupName from table.

in form, you can Group the controls in the Ribbon->Arrange->Size/Space->Group.