How do I set HideDuplicates property with VB

G

Guest

Need to set HideDuplicate property at runtime.

I have tried the following:
Me.Text7.HideDuplicates = True and also Me.Text7.HideDuplicates = -1

Both lines have created error 2448:You can't assign a value to this object.

Microsoft Access Help indicates that "You can set this property by using the
control's property sheet, a macro, or Visual Basic.

Looking for a Visual Basic sample
 
K

Keith Wilby

MLockey said:
Need to set HideDuplicate property at runtime.

I have tried the following:
Me.Text7.HideDuplicates = True and also Me.Text7.HideDuplicates = -1

Both lines have created error 2448:You can't assign a value to this
object.

Microsoft Access Help indicates that "You can set this property by using
the
control's property sheet, a macro, or Visual Basic.

Looking for a Visual Basic sample
Click to expand...

The help also states "You can set the HideDuplicates property only in report
Design view." - you don't actually state that it's a report you're working
on ...

Regards,
Keith.
www.keithwilby.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HideDuplicates Property 1
AllowDesignChanges property can not be set? 1
How to total the numeric number if it's repeating after grouping 2
Access Access macro build gone wrong 0
Property Popup gives an error 2
Setting popup & modal properies dynamically in a report 2
Change form property at runtime 5
Setting MultiSelect Properties to a ListBox at Runtime 4

Top