Prev: What to charge?
Next: Linked Table in Access database
From: Steve on 12 Feb 2010 09:20
Tryng to add a formula for a field in a table. In the property sheet all i
see is the General tab. Where are the rest of the tabs? (Format, Data, Event,
Other, All). Is the DB protected some how? Trying to access property sheet
control source field.
From: Dirk Goldgar on 12 Feb 2010 10:17
"Steve" <Steve(a)discussions.microsoft.com> wrote in message
news:2D94D534-00C4-4EF3-B046-BEB5597C123A(a)microsoft.com...
> Tryng to add a formula for a field in a table. In the property sheet all
> i
> see is the General tab. Where are the rest of the tabs? (Format, Data,
> Event,
> Other, All). Is the DB protected some how? Trying to access property
> sheet
> control source field.


In a *table*? You mean with the table in design view? All the properties
of a field in a table are presented in the bottom pane of the design view
window. If you bring up the Properties window, all you get are the
properties of the table.

And table fields do not have events or controlsources.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

From: KenSheridan via AccessMonster.com on 12 Feb 2010 11:54
What you appear to be referring to is a form, not a table. A table, i.e. a
base table rather than the result table of a query, simply holds data as
values in columns in rows. If you want to compute a value form other values
by means of an expression (formula is a spreadsheet term), then you can do so
in a computed control in form based on the table by entering the expression
as the Control's ControlSource property. The form can be opened in datasheet
view if you wish and will show any computed controls as columns in addition
to the table's columns.

Ken Sheridan
Stafford, England

Steve wrote:
>Tryng to add a formula for a field in a table. In the property sheet all i
>see is the General tab. Where are the rest of the tabs? (Format, Data, Event,
>Other, All). Is the DB protected some how? Trying to access property sheet
>control source field.

--
Message posted via http://www.accessmonster.com

 | 
Pages: 1
Prev: What to charge?
Next: Linked Table in Access database