View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default "Abnormal behaviour" data entry form

If a field contains a formula it will be blocked on the data form. Do
the entries in the first data row contain formulas?

JR Hester wrote:
CAn anyone offer an explanation of why a data entry form( DataForm) would
block data of first 3 of four fields when attempting to add a "new" record?
Admittedly, I had an ill conceived layout( on purpose ). field labels were in
row 4 AND some field labels originally included spaces. The data form
correctly displayed existing records, but when attempted to add a record with
the NEW button, only the last field open a text box for data entry.

I corrected the known issues, deleted rows 1-3, and removed spaces from
field names. This did NOT resolve the data form issue.

NOTE: Pasted data into a new spreadsheet and the data entry form works
normally. Anyone have an idea of what may casue such behaviour? And is there
any suggested work around other than the method I used? facilitating a
trining exercise and looking for answer BEFORE I am asked the question.

Thanks



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html