Keep data from a field together as typed

  • Thread starter Thread starter dcrqueens
  • Start date Start date
D

dcrqueens

I have created a report and set the Can Grow set to Yes to a field. Physical
space is limited on the report so the field size is not that large. The issue
I am having is that when the field prints (text field) some of the
information does not stay together. For example the field can have the
following listed:

RES-45% COM-12% HOM-55%

Since the field is not large the data will get pushed to another line and
breaks in the wrong place (ex HOM-12% will be listed as CO then the rest gets
pushed to another line) It makes reading the field hard to follow. When I am
entering the data into my form is there a certain way I can enter it to make
sure that the data breaks where I want it to? Or, is there another way to fix
this problem?

Thank you in advance,

dcrqueens
 
If you are saying that "RES" and "COM" and "HOM" are different facts (or
the combination of "RES-45%" is two facts, so what you provided is actually
6 facts in one field, then consider revisiting your database design. If you
have more than one fact in one field, you may be looking at a one-to-many
relationship, which requires TWO tables in Access, not one.

Regards

Jeff Boyce
Microsoft Access MVP
 
I must agree with Jeff. Three different categories should ideally create
three records in a related table.
 
Hi Jeff thank you for the response. Actually the field is for Initial Rates.
Yes the rates are for 3 different categories (but for the same client), but
they are all Initial rates. When the data was in an excel spreadsheet they
were all listed together in one cell (Initial rates and then another cell for
Final Rates). The data that is listed in the field only apply to that one
record. Do you still think I need to keep just that one field in a separate
table?
 
So you have 'categories' and 'percentages' and "initial" vs. ???

.... and you are saying, I suspect, that whatever you are recording data
about can have as many as 3 "categories" (or could there be one or two or
seven or none?).

This situation (a one-to-many relationship) calls for tables like:

tblWhatever
WhateverID
(whatever facts relate ONLY to each Whatever)

tlkpCategory
CategoryID
Category (your "RES", "HOM", ...)
CategoryDescription (what does "RES" stand for?... "HOM" ...? ....)

tlkpSomeOtherCategorization (your "initial" vs. ...)
SomeOtherCategoryID
YourOtherCategory (if some facts can be "initial", other facts may
be ...?!)
YourOtherCategoryDescription

trelWhateverCategory (i.e., for each valid combination of your Whatevers
and your Categories)
WhateverCategoryID
WhateverID
CategoryID
YourMeasurement (depends on how/what you are measuring, may be your
'percentage')
SomeOtherCategoryID (i.e., is this the "initial"
measurement/assessment/??? or ...)

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP
 
Back
Top