How can I bind the caption property to a database field.

Hi phxdatadr,

You can't "bind" it to a field, but in the form on current event you can set
the caption to a field like this:

me.CONTROL.caption = me.FIELDNAME

Assuming the control supports the caption property...

Hope this helps.

Damian.

"phxdatadr" wrote:

> How can I bind the caption property to a database field.

It is like this .
I have a table with restaraunt menu items in it. I want to dynamically
populate a form with a button for each item in the table and then have the
the caption property dynamically populated with the menu_item field in the
table.

"Damian S" wrote:

> Hi phxdatadr,
>
> You can't "bind" it to a field, but in the form on current event you can set
> the caption to a field like this:
>
> me.CONTROL.caption = me.FIELDNAME
>
> Assuming the control supports the caption property...
>
> Hope this helps.
>
> Damian.
>
> "phxdatadr" wrote:
>
> > How can I bind the caption property to a database field.

Hi again,

Perhaps you could have a combo box for the user to select the item, and a
single button on your form to process the selected item. This would be
easier and cleaner than creating (potentially many) buttons on the fly.

Damian.

"phxdatadr" wrote:

> It is like this .
> I have a table with restaraunt menu items in it. I want to dynamically
> populate a form with a button for each item in the table and then have the
> the caption property dynamically populated with the menu_item field in the
> table.
>
> "Damian S" wrote:
>
> > Hi phxdatadr,
> >
> > You can't "bind" it to a field, but in the form on current event you can set
> > the caption to a field like this:
> >
> > me.CONTROL.caption = me.FIELDNAME
> >
> > Assuming the control supports the caption property...
> >
> > Hope this helps.
> >
> > Damian.
> >
> > "phxdatadr" wrote:
> >
> > > How can I bind the caption property to a database field.

Hi,
you can just use a textbox, which you can easy bound, instead of label, just
set it's properties Enabled=False, Locked=True

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"phxdatadr" <(E-Mail Removed)> wrote in message
news:2AFC1EDC-12C8-4780-AECC-(E-Mail Removed)...
> How can I bind the caption property to a database field.

I have a table with restaraunt menu items in it. I want to dynamically
populate a form with a button for each item in the table and then have the
the caption property dynamically populated with the menu_item field in the
table. the contol has to be a button as this is a touch screen POS system.

Then you can still use textbox, but place transparent button over it (if
this works in touch screen POS system)

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"phxdatadr" <(E-Mail Removed)> wrote in message
news:61BDC7D5-B94E-403E-A2A1-(E-Mail Removed)...
>I have a table with restaraunt menu items in it. I want to dynamically
> populate a form with a button for each item in the table and then have the
> the caption property dynamically populated with the menu_item field in the
> table. the contol has to be a button as this is a touch screen POS system.
>