473,503 Members | 1,697 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Subform Columns and Data Appearance

1 New Member
I have a subform and I have a query. The query is a crosstab query. It has numbers (aggregated) as a result. I want to change those numbers to "X" just to indicate that some value exists to the user viewing the form. How do I do that?
Jul 4 '11 #1
1 1399
NeoPa
32,557 Recognized Expert Moderator MVP
In the controls that you have to reference the fields (Let's call the field [FieldName] for now) you would use a formula such as :
Expand|Select|Wrap|Line Numbers
  1. =IIf([FieldName] Is Null,'','X')
Do you see how that would work? BTW I'm assuming your question is correct and you really are asking about values being present as opposed to values being non-zero. That would be a different formula of course (but the same concept).
Jul 4 '11 #2

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

Similar topics

0
2354
by: Irwinsp | last post by:
Hi All, I have a form that needs to be placed on the web. The form contains a subform. The relationship from the form to the sub-form is 1 to many. Can this type of form be converted to a Data...
1
3819
by: noone | last post by:
I'm making a sales order database similar to Northwinds but with a slightly different form. The tables are the same. The 'Sales Orders' form has a 'Line Items' subform. I've added a 'Add Item'...
1
1657
by: Jimmy | last post by:
Does anyone know if refreshing particular row data possible in subform? For example: Subform has two field: Vendor and product In first row, is it possible that when you select a vendor only...
1
2287
by: Richard Sherratt | last post by:
I added a new field to a table in the tables database. In the code database, I added a new column for the new field to a datasheet subform. I opened it in datasheet view and moved the column to the...
10
1696
by: sara | last post by:
Hi - I am developing a simple app, and just found a problem that I can't fix after 4 hours of trying. I display a list of customers, and the user chooses one and displays "orders". The...
1
1257
by: David | last post by:
Using Access 2002. I have a form with several subforms. Subform2 allows the user to insert a record into a table. One of the fields in this table is an account number, which is displayed in...
7
3395
by: FNA access | last post by:
I have a mainform that has a subform in the detail section and a subform in the footer section.(Both subforms are in datasheet view) When I click the navigation button to create a new record on the...
0
1062
by: tasawer | last post by:
Hi, I have mainform with AccidentID linked to subform that has maximum 4-rows of information for each main ID. Four each row of information, I have: item-Cost - Discount - Paidyn items are:...
5
3922
mseo
by: mseo | last post by:
hi, I have mainform with two cmdbuttons: 1- Save 2- Add Detail the mainform has subform which is set to invisible, if I click Add Detail the subform appears, if not and user clicked Save the...
2
2933
by: cambar | last post by:
When Access db is first opened and the first record is entered, tabbing on subform works properly. However, when subsequent records are entered, the subform retains memory of the last field filled in...
0
7074
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7273
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7451
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5572
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5000
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4667
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3150
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
731
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
374
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.