By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,397 Members | 2,552 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,397 IT Pros & Developers. It's quick & easy.

Desired column displays in Form but not in Report

100+
P: 161
I have a report displaying the wrong field value. In the form it displays "inches" but uses "gallons" for calculations which works as needed. However when I open in report view it displays "gallons" but it must display "inches" at the minimal or even both would be acceptable. Currently in the form I have the data settings Bound Column 2. Format settings Column Count 2, Column widths 0.85";0". (I was able to correct similar issues by changing the bound column but in this scenario it messes up my calculations).

Update the table look like this:
Inches Gallons
0 15000
1 14500
2 14000
Apr 7 '19 #1
Share this Question
Share on Google+
6 Replies


100+
P: 161
I made a error in the question and title, apologies. The tables in question do not have a PK. The report was showing the 2nd field and the form was showing the first field. I do not know if my solution for the remainder of my question is correct but to get the display values correct I....

In the report I changed the textboxes to Comboboxes. Then I left the control source alone, I added my chart tables to the row source, set the bound column to 2, finally set column count to 2 and column widths to 0.85",0"

I do not see how to update the question. Hopefully someone can update to remove the PK portion and indicate undesired column displaying instead.
Apr 7 '19 #2

NeoPa
Expert Mod 15k+
P: 31,494
I'm a little confused. I see that you have managed to edit your OP, but your second post asks for help as you can't. Maybe the second post came before the update but certainly what the current situation is, is not clear.

I can make changes to the question, even the title, for you if you can explain clearly what you want in place of the existing ones. You can PM me your requirements if you'd like. Alternatively, if you're happy now, just let us all know so we can get on with trying to answer your question. I must admit that, reading it, I was quite confused as to what you were trying to describe as the problem. If it doesn't need changing though then I'll read it again and try to work out what is meant.
Apr 7 '19 #3

100+
P: 161
It has to do with ComboBoxes and bound columns. In this instance column 1 is inches and column 2 is gallons. Entering information I need inches to be displayed but I need the bound column to be gallons for calculations in the form view.

In the report view it shows the bound column which is gallons rather than inches which is the desired view. I was able to correct this by changing the textboxes in the form to ComboBoxes and setting the columns there. Iím sure thereís a better way but it appears to be working.
Apr 8 '19 #4

NeoPa
Expert Mod 15k+
P: 31,494
The other way would be to include the extra data as a field in the query used in your RecordSource property. That way you could have either or both sets of information and a simple TextBox would work for you easily.
Apr 8 '19 #5

100+
P: 161
Iíll give it a try tomorrow. Thanks
Apr 8 '19 #6

NeoPa
Expert Mod 15k+
P: 31,494
Data for Niheel. Please delete when no longer required.

Here's what it looks like on my system :


I get there by clicking :


This is found at the bottom of the thread page.
Attached Images
File Type: jpg EditThread.jpg (167.5 KB, 157 views)
File Type: jpg EditThreadLink.jpg (92.8 KB, 157 views)
Apr 13 '19 #7

Post your reply

Sign in to post your reply or Sign up for a free account.